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

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

Regards,

Peo Sjoblom

"jackies_place" wrote:

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