View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kerry Kerry is offline
external usenet poster
 
Posts: 72
Default Order of Numbers

I am looking to be able to put values in the order of 1 to 5 in a range of
cells based on the order of values in another range - as an example the
values in range (row) one may be 12,36,25,40,19 which would result in this
being shown in the 'order' range as 5,2,3,1,4. Hope this makes sense