Excel Spreadsheet problem
I would really appreciate some help with a simple scoring spreadsheet I have constructed.
Column A, rows 3 - 38 are team names
Columns B to X are weekly scores
Column Y is cumulative total score
Column Z is ranking.
For the ranking I have used the RANK function.
The formula for the ranking for row 3 is therefore =RANK.EQ(Y3,Y$3:Y$38)
This works fine, but I want to get an equals sign after any equal ranking, ie;-
1
2
3=
3=
4
5
etc
Can anyone offer the solution? any help greatly appreciated.
Cheers
HM