Excel Ranking Formula

Hi Folks,

Im using the standard rank formula to attribute rankings to 18 sites based on current performance.

If 2 sites say, come equal 6th is there a way to actually show the = sign in front of the ranking. i.e =6

Thanks in advance.

BMC

If data to rank is in A2:A19 use this formula in row B2 copied down

=IF(COUNTIF(A$2:A$19,A1)>1,"=","")&RANK(A2,A$2:A$19)