Match case

[taskmaster]

Hi,
I am trying to match 2 different sets/array of data and see if there will be
any common digit. If there is a common digit I need a "YES" else a "NO". I am
using MS Office 2003.

 

[ShaneDevenshire]

We need more info. Show us some sample data, tell us which ones meet your
definition of matching.

For example
1 3
4 78

2 3
1 23

Is there one match here 3=3
are there 2 matches here 3=3 and 1=1 (they are in a different place)
are there 3 matches here 3=3, 1=1 and 3=23 because 3 is a matching digit?

 

[taskmaster]

Hi Shane

The first two hold good..they can be in the same place or different places.

Say

Set1 Base Set
12 23
23 24
24 25
56 26

Set1 has 2 matches (23 & 24) when compared to Base set though in different
places.

Thank you!

 

[taskmaster]

Hello there!!

Can anyone help on this??

Hi Shane

The first two hold good..they can be in the same place or different places.

Say

Set1 Base Set
12 23
23 24
24 25
56 26

Set1 has 2 matches (23 & 24) when compared to Base set though in different
places.

Thank you!