Formula =Rank - Microsoft Community

i have column in each row following numbers appear. a1=7, a2=5,a3=4, a4=5.

i using formula this.

=if(a1,rank(a1,$a$1:$a$4,$c$1:$c$4),0)

because have column must rank.

the formula works, a2=5 , a4=5. both rank result of 2 , there no 3.

i want other way round.

a2 , a4 must both 3 , number 2 must left out.

so want higher number result.

is possible please.

i thank results i've asked in past have never failed me. 

 

put formula:

=rank(a1,a:a,1)+countif(a:a,a1)-1

in cell b1, , copy down.

Office / Excel / Windows other / Office 2010