EXCEL - How to remove ALL duplicates - not just the duplicate

0

I have a problem that is getting worse every time ..

I have a spreadsheet of user data for a company - where the key is the email of the official.

I need to update this listing on a monthly basis including the NEW contractors and EXCLUDE those dispensed.

  • Include new employees ok (so insert)

The problem is in the DELETE section.

I always get a new spreadsheet - one for NEW and one for DISPENSED.

The spreadsheet has the same information as the final spreadsheet - so the email has tb.

So - it's "SIMPLE" - just identify the duplicate emails.

Ate there - just use the validation rule - and mark the duplicates.

BUT .. how do I delete it?

Excel only allows you to delete the REPEAT. Keeping one on the list.

In my case I need to ELIMINATE EVERYTHING.

Both the repeated and the original - already the idea is to remove the dispensed from the listing.

Until now I have managed to do it manually - checking the duplicates by validation - and checking line by line.

BUT THE LIST TODAY JA IS WITH 20 THOUSAND OFFICIALS .. what will become unfeasible to be doing one by one ..

Is there any way to do this in a more automated way?

Thanks!

DANIEL

    
asked by anonymous 15.06.2018 / 17:44

0 answers