in excel, how do I find which values doesn't have a pair?

[jackies_place]

I have a list with many values that are listed twice, how do I find which
values DON'T have a pair?

 

[Peo Sjoblom]

You can just extract the unique records using data>advanced filte,r unique
records only. To tag those that don't have pairs see:

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

Regards,

Peo Sjoblom

 

[Frank Kabel]

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