I have a list with many values that are listed twice, how do I find which values DON'T have a pair?
C curiousjackie Dec 17, 2004 #1 I have a list with many values that are listed twice, how do I find which values DON'T have a pair?
T tjtjjtjt Dec 17, 2004 #2 Here's a previous thread that may help http://www.microsoft.com/office/com...dfda&mid=96064307-bb0d-4fb0-b4de-20679c58dfda tj
Here's a previous thread that may help http://www.microsoft.com/office/com...dfda&mid=96064307-bb0d-4fb0-b4de-20679c58dfda tj
D Dave O Dec 17, 2004 #3 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.
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.
