View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] ilovekids123@gmail.com is offline
external usenet poster
 
Posts: 4
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?