Hi Happy,


See Chip Pearson's Tagging Duplicates page at:

http://www.cpearson.com/excel/duplic...gingDuplicates

See particularly the section entitled:

'Extracting Values On One List And Not Another'


---
Regards,
Norman



"Happy" wrote in message
...
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.