|
Re: Rank Function
Or to keep the test down to one calculation:
=IF(ISNUMBER(A2), RANK(A2, A$2:A$30,0), "")
NOTE: Zero evaluates as a number, so zeros would generate a rank, and blank cells or null cells would not.
__________________
If you've been given good help, use the  icon in that post to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
|
Linear Mode
