We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to Add a Count to the Number repeating in excel

nkumarjha
7 - Meteor

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 ID
450-0537211
450-0537212
450-0537213
450-0537214
550-0096021
550-0096022
550-0096023
550-0096024
550-0101441
550-0101442
550-0101443
550-0101444

 

 

4 REPLIES 4
DavidP
17 - Castor
17 - Castor

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

carlosteixeira
15 - Aurora
15 - Aurora

Hi @nkumarjha 

Holp this help

 

Carlos A Teixeira
nkumarjha
7 - Meteor

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
7 - Meteor

Thanks a lot @DavidP 

 

Tile worked and i have the results.

 

Regards

Nav

Labels