Filtering data that do not appear on another worksheet

**dtrimble** · 05-01-2014, 05:52 PM

Can anyone offer any suggestions on how to highlight, filter, or otherwise in someway mark all records on a spreadsheet that do not appear on another spreadsheet?

On Worksheet1, I have columns of data for First, Middle, Last, Clock Number, Address 1, Address 2, City, State, Zip Code and Employment Status. On Worksheets 1 and 2, the data and columns are 100% identical, except Worksheet1 has names I want excluded from a database import process I'll be running on the 2nd worksheet.

Is there an easy way or a quick VBA script someone could help with that would allow me to highlight or filter out of Worksheet1 any rows that are not in 2?

**TMS** · 05-01-2014, 06:13 PM

You could add a Helper column and use a COUNTIF function.

Formula:

=COUNTIF(Worksheet2!LastName, LastName)

Those that don't appear will have a zero count.

If you need to combine the First, Middle and Last Name, you could have a Helper column on both sheets and concatenate the values. Then use the COUNTIF and filter.

Regards, TMS