sort rank
 

I am using the below formula to rank a column. I want whoever has the lowest
number to be ranked #1 and so forth. Any suggestions?

=IF(A1="","",SUMPRODUCT(--(A1<A$1:A$12),1/COUNTIF(A$1:A$12,A$1:A$12&""))+1)

sort rank
 

Why not simply use:
=IF(A1="","",RANK(A1,A$1:A$12,1))

And copy down.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jennifer" wrote:

I am using the below formula to rank a column. I want whoever has the lowest
number to be ranked #1 and so forth. Any suggestions?

=IF(A1="","",SUMPRODUCT(--(A1<A$1:A$12),1/COUNTIF(A$1:A$12,A$1:A$12&""))+1)

sort rank
 

Jennifer,

Change

A1<A$1:A$12

to

A1A$1:A$12


HTH,
Bernie
MS Excel MVP


"Jennifer" wrote in message
...
I am using the below formula to rank a column. I want whoever has the lowest
number to be ranked #1 and so forth. Any suggestions?

=IF(A1="","",SUMPRODUCT(--(A1<A$1:A$12),1/COUNTIF(A$1:A$12,A$1:A$12&""))+1)

sort rank
 

Luke,

Why not simply use:

Because your formula handles ties differently than hers.

HTH,
Bernie
MS Excel MVP