asked on

Excel Check Duplicates/Blanks in One Column, If Duplicate/Blank in that Column, Remove Entire Row of Duplicate/Blank

Hi Experts,

Thanks for reading. I'm working with Excel 2010 in Office for Windows. I'm looking to check if there are duplicates/blanks in Column C, and if there is duplicates/blanks, remove the entire row that that duplicate/blank is on (e.g. Remove Column A & B value of the row the duplicate/blank is on as well as Column C where the duplicate/blank is).

How can I go about achieving this?

Thank you.

nutsch

Use the remove duplicates function

Data \ Remove duplicates

Thomas

PS Screencast coming soon.

ASKER CERTIFIED SOLUTION

nutsch

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SevenAteAnthony

ASKER

Thanks, nutsch. That got rid of the duplicates. How can I remove the blanks now?

SevenAteAnthony

ASKER

Thanks for the Screencast, nutsch. In 2010, it does not seem to remove the blank fields of the entire row when you just select Column C, though...

nutsch

Are your blanks on column C? If yes, the remove duplicates should remove all but one of them. If not, you can do an autofilter (Data \ Filter \ Blanks) then delete the selected lines.

T

nutsch

Make sure all your data is selected first. Excel will only guess the data range if there are contiguous non-empty cells. A full empty row will stop the range from being extended.

T

SevenAteAnthony

ASKER

Just kidding, it worked when I messed around with it further. Thanks very much.

nutsch

Glad to help. Thanks for the grade.

T