Duplicate Information to be removed from different rows

Good Day,

I'm busy cleaning information from an excel spreadsheet. Not all the columns are populated. e.g. Row 17 will only have an email address in column E whilst row 18 will have a name, surname, company and email address (same as in row 17).

Using the remove duplicate function, removes row 18 and thus leaves me with the row that only contains the email address.

What would it take for me to be able to remove the rows that do not have the additional columns populated?

Assistance will be greatly appreciated.

Regards,


Charlinda

Are you just trying to remove the rows with partial data?

You can select a range where there are blanks, use Find & Select -> Special, Choose Blanks. Then under Cells -> Delete, choose Delete Rows.

This will eliminate only the rows in the range you selected that contained blanks.


For example, if you have data in A2:M5000, but a lot of entries have partial data in A2:C5000. Just select A2:A5000, Find & Select -> Special, Choose Blanks. Then under Cells -> Delete, choose Delete Rows. Now each row that contained a blank in just Column A will be deleted.

Hallo,

Thank you for your response.

Example.jpg

It's important for me to keep the email addresses. If you refer to the attached, I would like to keep row 2 (even though there's no detail in other columns.)

Row 3 and Row 4 has the same email address, I would like to keep Row 4 and Row 3 should be deleted.

Other examples: keep Row 8 delete Row 7, keep 12, delete 13, keep 14.

Sadly I'm not too familiar with excel or the correct terminology and I hope this makes more sense

Regards,

Charlinda