| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find common text in cell in column in sheet then return total amou | Excel Worksheet Functions | |||
| How to find common strings of text then copy those rows elsewhere? | Excel Worksheet Functions | |||
| How do I find the 6 most common | Excel Discussion (Misc queries) | |||
| need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
| I need to find odd numbers in a column | Excel Worksheet Functions | |||
Linear Mode
