filtering out data using other worksheet

[Guest]

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]

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'