title: Index values in Excel - Highest value is X, lowest is Y and all in between is divided in between X and Y
body: <p>I need to index prices in Excel, so the highest price is 5 and the lowest is 1.
  All the prices in between needs to be automatically sorted and given a value, depending on the amount of entries.</p>
  <p>eg.</p>
  <p>8$ -&gt; 5.0  (Highest price = index score 5)</p>
  <p>3$ -&gt; 1.0  (Lowest price = index score 1)</p>
  <p>7$ -&gt; 2.5  (Price between the highest and lowest, gets a weighted score, depending on amount of entries in the list)</p>