How to Add a Count to the Number repeating in excel

[nkumarjha]

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 

Number	Rank ID
450-053721	1
450-053721	2
450-053721	3
450-053721	4
550-009602	1
550-009602	2
550-009602	3
550-009602	4
550-010144	1
550-010144	2
550-010144	3
550-010144	4

[DavidP · Accepted solution]

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

[carlosteixeira · Accepted solution]

Hi @nkumarjha 

Holp this help

[nkumarjha]

Thanks a lot @carlosteixeira 

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

Regards 

Nav

[nkumarjha]

Thanks a lot @DavidP 

Tile worked and i have the results.

Regards

Nav