Compare duplicate rows, identify most recently added

Stefanie S.

I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank you.

Carson Penticuff

This should work with only one caveat... if multiple entries have the same date and time (down to the minute), they will not be marked as duplicates.

=IF(AND([Created]@row <> "", NOT([Created]@row = MAX(COLLECT(Created:Created, ID:ID, ID@row)))), 1, 0)

Carson Penticuff

This should work with only one caveat... if multiple entries have the same date and time (down to the minute), they will not be marked as duplicates.

=IF(AND([Created]@row <> "", NOT([Created]@row = MAX(COLLECT(Created:Created, ID:ID, ID@row)))), 1, 0)

Stefanie S.

This works perfectly - thank you so much!

Carson Penticuff

I'm glad I could help!