I need to remove rows based on duplicate column content
enter image description here
In the above photo, I would like rows 1 and 3 removed since column A = column D.
so if COLUMN A = COLUMN D then delete row.
Thanks!
enter image description here
I have tried filtering by columns, but my spreadsheet is 15k lines, with over 1000 unique values for columns A and D
New contributor
Samantha Hall is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.