Delete Unwanted Data

[Happy]

I have 2 set of data.
- whole school students' names
- special students' names

how can I produce delete special students' names from the whole school list
to produce a 'whole school without special students' list'?

any help appreciated.

 

[Norman Jones]

Hi Happy,


See Chip Pearson's Tagging Duplicates page at:

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

See particularly the section entitled:

'Extracting Values On One List And Not Another'