in excel, how do I find which value 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?

Here's a previous thread that may help:
http://www.microsoft.com/office/comm...e-20679c58dfda

tj

"curiousjackie" wrote:

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

One way is to use the COUNTIF() function. Suppose your list runs from
A1:A10. In cell B1, enter
=COUNTIF($A$1:$A$10,A1)
and copy this down to B10. Any unique entry will show a result of 1.

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

--
Regards
Frank Kabel
Frankfurt, Germany
"curiousjackie" 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?