View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Uka P.
 
Posts: n/a
Default comparing tables/vectors

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.