Multi Row Formula

[sariyaj]

Hello, I'm having trouble with the multi row formula. I am trying make it so that if the row above it is a duplicate, I want it to add one, two, three, etc. 

for example:

Company Code	Company Name
ABC001	ABC Trucking
ABC001	ABC Equipment
ABC001	ABC Services
ABC001	ABC LLC

but I need it to look like this:

Company Code	Company Name
ABC001	ABC Trucking
ABC002	ABC Equipment
ABC003	ABC Services
ABC004	ABC LLC

Any kind of help would be appreciated. 

Thank you.

[FinnCharlton]

Something like this might help:

[sariyaj]

I'm sorry but what is the multi Row formula you used?

[FinnCharlton · Accepted solution]

if [Row-1:Company Name]!=[Company Name] then tonumber([Row-1:New Field])+1 else tonumber([Row-1:New Field]) endif

This checks to see if the row above is a duplicate. If it is not, it adds 1 to the "New Field" column. At the moment if the row above is a duplicate, the formula just returns the same "New Field" value as the row above. This part could be changed depending on what output you want when there is a duplicate.

[sariyaj]

That worked great! Thank you so much!

[binuacs]

@sariyaj Another way of doing this with the tile tool