Delete rows with duplicate data

Hi @Eden

I would use the move rows automation to move (or delete from the sheet) the row with the same column1 value as the previous row (the row is in the upper position in a sheet).

We need helper columns like row no, Rankeq, and Duplicates to do that.

Rankeq

• =RANKEQ([Row No]@row, COLLECT([Row No]:[Row No], [Column1]:[Column1], [Column1]@row), 1)
• Meaning: Collect Row Nos that have the same Colum1 values and rank them.

Duplicates

• =IF(Rankeq@row > 1, 1, 0)

Move rows workflow automation

When the "Duplicates" column values become checked, move the row to another sheet.