RANK function without the cells being sorted??

  • Thread starter Thread starter PZ Straube
  • Start date Start date
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!
 
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
 
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.
 
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
 
Back
Top