Match case

T

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

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?
 
T

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!
 
T

taskmaster

Hello there!!

Can anyone help on this??

taskmaster said:
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!
Click to expand...
 
Top