View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Is there a reverse to RANK?

RANK gives you the position of a particular number in a list.

I need a function that is RANK's reverse. I want to give the position, and
have the function return the number in that position.

Couldn't find it on first glance. Is there such a thing?


Have a look at the INDEX() and MATCH()functions

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion