I have a spreadsheet that contains a list of names.
The names were listed several times and was entered into different rows.
For Instance, the name “Diego Garcia” was listed 6 times, and each appearing in a row. So Diego Garcia were listed in 6 rows.
What I would like to do is to automatically delete the duplicate name entry by deleting the whole row.
I’am talking about 40k listed names here, all have duplicates.
You may have a look at the sample data I’m working on right now. See attached image.
From the attached image, I’d like to do the following;
Leave row 1292
Delete rows 1293 - 1304