Hi I am trying to rank the repetitive number, can some one please suggest an idea. below is the data set and excel attached, Thanks a lot for your Help Nav NumberRank ID450-0537211450-0537212450-0537213450-0537214550-0096021550-0096022550-0096023550-0096024550-0101441550-0101442550-0101443550-0101444 test.xlsx

How to Add a Count to the Number repeating in excel

I am trying to rank the repetitive number, can some one please suggest an idea. below is the data set and excel attached,

Thanks a lot for your Help

Nav

Use a Tile Tool - Unique value set as [Number]

Holp this help

Use a Tile Tool - Unique value set as [Number]

Holp this help

Tile did work. Some how the row comparison is giving error. but i was able to achieve the result.

Regards

Nav

Thanks a lot @DavidP

Tile worked and i have the results.

Regards

Nav