How to compares sets of numbers

A

António

Hi all,

Need help for the following

Have to find how many numbers of set2 (lenght 6 to 28) are contained on set1 (lenght varies from 9 to 81).

Can any one help

Tks in adv
 
M

macropod

Hi António,

You could use something like:
=SUM(IF(COUNTIF(Set1,Set2),1,))
entered as an array formula (Ctrl-Shift-Enter)

Cheers

António said:
Hi all,

Need help for the following

Have to find how many numbers of set2 (lenght 6 to 28) are contained on
Click to expand...
set1 (lenght varies from 9 to 81).
 
Top