Un-Skipping the Rank after a duplicate value to get a regular Series!
Col A ------ Col B ------ Col C ------ Col D
Players ------ Scores ------ Rank ------ Answr
SACHIN ------ 186 ------ 1 ------ 1
DHONI ------ 183 ------ 2 ------ 2
KAPIL ------ 175 ------ 3 ------ 3
HAYDEN ------ 175 ------ 3 ------ 3
SEHWAG ------ 167 ------ 5 ------ 4
BORDER ------ 158 ------ 6 ------ 5
RAHUL ------ 152 ------ 7 ------ 6
LARA ------ 148 ------ 8 ------ 7
RICKY ------ 148 ------ 8 ------ 7
KEVIN ------ 142 ------ 10 ------ 8
BOON ------ 133 ------ 11 ------ 9
FLINTFF ------ 119 ------ 12 ------ 10
BOTHAM ------ 112 ------ 13 ------ 11
I want to prevent the skipping of numbers while using the RANK function which skips the next number when it hits a duplicate value..
I want to get the rank as well as not have the next number skipped..
Warm Regards
e4excel
Bookmarks