• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • Last Modified:

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.
0
SevenAteAnthony
Asked:
SevenAteAnthony
  • 5
  • 3
1 Solution
 
nutschCommented:
Use the remove duplicates function

Data \ Remove duplicates

Thomas

PS Screencast coming soon.

0
 
nutschCommented:
You will need to delete the last blank row by hand. Here is the screencast.

Thomas
nutsch-516566.flv
0
 
SevenAteAnthonyAuthor Commented:
Thanks, nutsch. That got rid of the duplicates. How can I remove the blanks now?
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
SevenAteAnthonyAuthor Commented:
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...
0
 
nutschCommented:
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
0
 
nutschCommented:
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
0
 
SevenAteAnthonyAuthor Commented:
Just kidding, it worked when I messed around with it further. Thanks very much.
0
 
nutschCommented:
Glad to help. Thanks for the grade.

T
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now