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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - in excel, how do I find which values doesn't have a pair? (https://www.excelbanter.com/excel-discussion-misc-queries/2127-excel-how-do-i-find-values-doesnt-have-pair.html)

jackies_place

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

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 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?

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany
"jackies_place" schrieb im
Newsbeitrag ...
I have a list with many values that are listed twice, how do I find which
values DON'T have a pair?

All times are GMT +1. The time now is 01:43 AM.