How to compares sets of numbers

[Guest]

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

 

[macropod]

Hi António,

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

Cheers

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).