From 2 rows or column how to find common numbers
 

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.

From 2 rows or column how to find common numbers
 

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...

"A S Matharu" wrote:

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.