RANK function

F

FLKulchar

Is there such a thing as a RANK function which returns
results...NOT in lowest to highest...but highest to
lowest??

In other words, if your array is 1,2,3,4,5,6,7,8,9,10...

and you ask the RANK function to return

(3,A1:A10)...instead of 3 for the result, I would like to
see 7!!

please advise,

larry
 
F

Frank Kabel

Hi
not quite sure if I miss something but why don't you use
=RANK(3,A1:A10)
though it will return 8 not 7 :)

For changing the order enter
=RANK(3,A1:A10,1)
this will return 3

HTH
Frank
 
F

FLKulchar

-----Original Message-----
Hi
not quite sure if I miss something but why don't you use
=RANK(3,A1:A10)
though it will return 8 not 7 :)

For changing the order enter
=RANK(3,A1:A10,1)
this will return 3

HTH
Frank


.
you are right...8, not 7..thanks for the (7,A1:A10,1)
Click to expand...

larry
 
Top