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

the cells that some rows have in common 1
How to count the numbers in a Word document? 0
Need Help with a VBA subroutine 0
Find values across a row and return a text value from the same column 3
Format column widths from one table to a separate table on same page 1
Cumulative formula for word table 0
Matching records based on a common field 1
delete rows between tow inputs numbers 3

Top