comparing number sets

[Chubster]

Hi,
I have two separate number sets:
Set 1 has 5 numbers 1-99 (A1:A5).
Set 2 has 10 numbers 1-99 (A6:A15).
Results Cell: prefer A17 (needs to be in same row as sets 1 & 2)

I'd like to compare the two sets as follows:

If there are zero matches between set 1 & set 2 then set 'results' cell to a "0".
If there is one number match between set 1 & 2 then set 'results' cell to a "1".
If there are two number matches between set 1 & 2 then set the 'results' cell to a "2"
If there are three number matchess between set 1 & 2 then set the 'results' cell to a "3".

thank you for your time,
Chubs

[rylo]

Hi

Try this

A17: =SUM(IF(ISNUMBER(MATCH(A1:A5,A6:A15,0)),1,0)) array enter the formula

HTH

rylo

[Chubster]

thank you.
I will give it a whirl and advise.

Chubs.