creating a RecordID for rows that have similar info

[codyfawcett]

I have a set of data that includes IP in column1 with header IP_Address

there are multiple rows that have the SAME IP, and I would like to increment the RecordID by 1 based on the IP
you can see a sample of the sanitized data below.

I am looking to get a record number added in the last column starting at 1 and as it finds a new IP in increment +1

so it would resemble this

I am trying to use the Multi-Row Formula tool

It almost works but it isn't incrementing correctly.  
Would anyone be able to help me out with the correct formula or tool for this?

[Thableaus · Accepted solution]

Hi @codyfawcett 

Use Tile Tool with Unique Value method. Unique field being your IP address. Much easier.

Cheers,

[codyfawcett]

Thanks for the super fast response!  that is exactly what I was needing.  used the unique fields no grouping then used the Tile_num as the incrementer.

Thanks!