Position in a list of numbers

  • Thread starter Thread starter dfuribe
  • Start date Start date
D

dfuribe

Hello, I hope someone can help me.

Is there a function (or a combination of function) to let me know in
which position of a list is a specific number?

For example, I have this list of numbers

76 102 100 96 95 86 85 77

And I want to know in which position (from smallest to largest, or
viceversa) number 96 is. In this case is the 6th smallest value.

Thank you for your help,

D.
 
With your numbers in A1:H1, and the number you are interested in (96)
in A3, put this formula in B3:

=RANK(A3,A1:H1,1)

It will return 6. Change the 1 to a 0 at the end if you want the
reverse order.

Hope this helps.

Pete
 
Look up the LARGE and SMALL functions in Excel Help.
It seems like one of them is what you're looking for.

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
OOOPS! Wrong functions (sorry)....Pete_UK got it right.

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Back
Top