From 2 rows or column how to find common numbers

A

A S Matharu

I have one row with 6 columns and having different numbers say from A1 to F1
Then i have one column with 20 different numbers say from H1 to H20. But
there are common numbers between this row and the column. I want to find the
common or repetitive numbers by comparing row with the column. And also tolal
common numbers between this row and column.
 
S

Sheeloo

One of the ways is to enter in I1 this formula
=IF(COUNTIF($A$1:$F$1,H1)=1,"Common","")
and copy down...
It will show you Common against the numbers in both lists...

This in J1 and copied down...
COUNTIF($A$1:$F$1,H1)*H1
will either show the number itself or 0 depending upon presence/absence in
the list...
 

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

Excel How to find the most common pairs and triplets numbers? 5
Find values across a row and return a text value from the same column 2
delete rows between tow inputs numbers 3
Excel sheet with numbers as column & row headers - How? 3
how do you have 2 criterias be picked up in a lookup? 2
Matching records based on a common field 1
Second Most Common Value 5
getting info from array but not using column / row numbers 4

Top