Scrub Excel table to show only listed criteria

[cfhasan89]

I have an Excel sheet with over 21,030 records (rows), that need to match against a List sheet with by two criteria. Criteria 1 = WUC and Crtieria 2 = POS. How can I vet the list to show only the listed criteria items? Also, list the criteria items not in the list being vetted? The List tab is the criteria and Physical Installed is the list being scrubbed.

 

[alansidman]

How can I vet the list to show only the listed criteria items?

Employ the filter that is on the Data Tab. Highlight your data and then filter the column for your items.

https://support.office.com/en-ie/ar...or-table-01832226-31b5-4568-8806-38c37dcc180e