sort rank

[Jennifer]

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)

 

[Luke M]

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

And copy down.

 

[Bernie Deitrick]

Jennifer,

Change

A1<A$1:A$12

to

A1>A$1:A$12


HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Luke,

Why not simply use:

Because your formula handles ties differently than hers.

HTH,
Bernie
MS Excel MVP