RANK function without the cells being sorted??

[PZ Straube]

I have 9 fields for several hundred rows of data. I need
to find a rank within each row for each of the 9 fields.
The RANK function appears to only work if the data is
already sorted. Is there another way to do this?
Thanks!

 

[Jerry W. Lewis]

Rank does not require sorted data (if it did, it would have no reason to
exist at all). You will have to give more information before we can
suggest how to make it work in your application.

Jerry

 

[Harlan Grove]

Rank does not require sorted data (if it did, it would have no reason to
exist at all). You will have to give more information before we can
suggest how to make it work in your application.

...

Given the existence of the & operator, there's no reason at all for CONCATENATE
to exist, but it does. Need and purpose are at best tenuous considerations for
what Microsoft adds to Excel.

 

[Jerry W. Lewis]

...

..

Given the existence of the & operator, there's no reason at all for CONCATENATE
to exist, but it does. Need and purpose are at best tenuous considerations for
what Microsoft adds to Excel.

Was this intended for a different thread? I don't follow what you are trying to say in this context.


Jerry