RANK function without the cells being sorted??

P

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!
 
J

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
 
H

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.
Click to expand...
...

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

Jerry W. Lewis

Harlan said:
...

..

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.
Click to expand...

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


Jerry
 
Top