I have a data file I would like to load. It has 4 columns and column 1 becomes the ID. I have a case where data in column 1 is duplicated but is unique to the record in column 3. Column header 1 is ID, column header 3 is M_D
I would like to write an IF statement, that if it's a duplicate record in column 1 to append the data with the contents of column 3.
Column 1 Column 3
What I would like to see in my ID field when loaded is:
The original formula is simply ID=DEAL but it fails when there is a duplicate.