Position in a list of numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dfuribe@gmail.com - 19 Sep 2007 00:01 GMT

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.

Reply to this Message

Pete_UK - 19 Sep 2007 00:09 GMT

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

On Sep 19, 12:01 am, dfur...@gmail.com wrote:

> Hello, I hope someone can help me.
>
[quoted text clipped - 11 lines]
>
> D.

Reply to this Message

Ron Coderre - 19 Sep 2007 00:12 GMT

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)

> Hello, I hope someone can help me.
>
[quoted text clipped - 11 lines]
>
> D.

Reply to this Message

Ron Coderre - 19 Sep 2007 00:16 GMT

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

Regards,

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

> Look up the LARGE and SMALL functions in Excel Help.
> It seems like one of them is what you're looking for.
[quoted text clipped - 23 lines]
>>
>> D.

Reply to this Message