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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

in excel, how do I find which values doesn't have a pair? 2
Excel Comparing two columns 1
Excel How to find the most common pairs and triplets numbers? 5
exchange columns according to some map regarding pairs of numbers 1
conditionally format pairs of cells in columns 1
How to create all possible pairs from a list of text data 2
Recommended Ryzen 3600 Motherboard, Memory and SSD 17
Matching pairs of Data in cell 1

Back
Top