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.
Solved! Go to Solution.
I'm sorry but what is the multi Row formula you used?
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.
That worked great! Thank you so much!