finding common data

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

Guest

I use Excel 2000, How do I find common data from 3 columns of different size?
For instance, finding a name that appears in all 3 columns
 
Suppose you have data in columns A to C. In D1 enter
=AND(COUNTIF($A:$A,A1)>0,COUNTIF($B:$B,A1)>0,COUNTIF($C:$C,A1))
and copy.
 

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

Comparing common values in either different worksheets or columns 1
Excel How to find the most common pairs and triplets numbers? 5
Most and least common 1
From 2 rows or column how to find common numbers 1
comparing two columns of data to find common values 2
VBA - retrieve data on last create named range from previous inserted named range 0
Most commonly dialled extensions 4
Reference Formula Help 1

Back
Top