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 CodeCompany NameABC001ABC TruckingABC001ABC EquipmentABC001ABC ServicesABC001ABC LLC but I need it to look like this: Company CodeCompany NameABC001ABC TruckingABC002ABC EquipmentABC003ABC ServicesABC004ABC LLC Any kind of help would be appreciated. Thank you.

Multi Row Formula

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.

Workflow

Accepted answers

FinnCharlton

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.