RANK function

[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

 

[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

 

[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)

larry

 

[Frank Kabel]

Hi Larry,
you're welcome
Frank