filtering out data using other worksheet

Guest · Sep 29, 2005

I have two worksheets, say worksheet wsA and wsB....
wsA and wsB are related by one field, say field1

I want to show only all data from wsA that does not have a matching data in
wsB.

What should I do? Thanks in Advance

Norman Jones · Sep 29, 2005

Hi Jaypee,

See Chip Pearson's Highlighting Duplicates page at:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

See particularly the section entitled:

'Extracting Values On One List And Not Another'

filtering out data using other worksheet

Guest

Norman Jones