View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cory from Eugene[_2_] Cory from Eugene[_2_] is offline
external usenet poster
 
Posts: 14
Default Questions about functions

I have a column of numbers, and what I want to do is return the 7 highest of
the numbers. Then, I want to be able to return the row number of each one
them. The only problem I have is, if two or more of the high numbers are the
same, it will keep returning the same the row number, instead of the next and
so on. And I CANT use the sort functions because I dont wanna mess up my
values

Any suggestions?

Please let me know. lol It's probably an easy answer, I just cant find it.