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?



--
Thanks,
Shane Devenshire


"taskmaster" wrote:

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.