Position in a list of numbers

[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.

 

[Pete_UK]

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

 

[Ron Coderre]

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)

 

[Ron Coderre]

OOOPS! Wrong functions (sorry)....Pete_UK got it right.

Regards,

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