Hi guys

How can I add a rank function to indicate

1
= (joint 1st) - if there is a tie
2
3
= (joint 3rd) - - if there is a tie

this would be based on the numbers (highest to lowest) listed in column E (e5:e40)

in columns A and B on the tab called: New1

So column A should say = (if there is a tie)
column B should say 1, 2, 3 etc


https://docs.google.com/spreadsheets...it?usp=sharing


thank you!