Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi there :-)
I have two columns with numeric data [but the kind of data shouldn't matter, I suppose]. They're of _different_ lenght, but there are empty cells below both of them. I want to compare the columns and get the _number_ [amount] of mutual elements as a result. Ie.: if A={2, 3, 5, 7, 9, 23, 25, 46}, and B={1, 3, 4, 6, 7, 8, 9, 46} than Result=4 If I defined the columns to have the same lenght [including some of the empty cells below] would the empty cells be counted as well? I wouldn't like that :-) Thanks in advance, regards. -- Uka P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing two spreadsheets | Excel Worksheet Functions | |||
Ignore Non-Alphanumerics When Comparing Text | Excel Worksheet Functions | |||
Comparing two lists in excel that don't match exactly | Excel Worksheet Functions | |||
Comparing Data in 2 columns | Excel Worksheet Functions | |||
Comparing Data in two columns | Excel Worksheet Functions |