title: Reverse this array formula
body: <p>Array - from helpful comment by user Barry Houdini (great name too)</p>
  
  <hr>
  
  <p>You can use PERCENTILE function in an array formula and get the result in one go, e.g. with data in A2:A29 try this array formula in B2</p>
  
  <p><code>=MATCH(A2,PERCENTILE(A$2:A$29,{5,4,3,2,1}/5),-1)
  </code></p>
  
  <p>confirm with CTRL+SHIFT+ENTER and copy down</p>
  
  <hr>
  
  <p>I should like to reverse this; as for my purposes a LOW score is better.</p>
  
  <p>It was not as simple as changing to {1,2,3,4,5}</p>