S
ste mac
Hi there, I need a bit of help,
If I have a range as the example below:
Range to check:
cells A1 B1 C1 D1 E1
value D G J K N
Range to check against:
cells H1 I1 J1 K1 L1
value D E G J K
I need to know how many matches there are ie
0 matches
1 match
2 matches
3 matches
4 matches
5 matches
The results in O1:T1
The twist is that the matches are only to be in the matching
position...ie the example above would only have one match, which
is "D" (A1 and H1)...even though there are four repeated values...
they are not in the matching postion, I am going to have to do this
lots and lots of times down a list. I want to try and do that bit...
Anybody know a fast way to check this?
thanks
ste
If I have a range as the example below:
Range to check:
cells A1 B1 C1 D1 E1
value D G J K N
Range to check against:
cells H1 I1 J1 K1 L1
value D E G J K
I need to know how many matches there are ie
0 matches
1 match
2 matches
3 matches
4 matches
5 matches
The results in O1:T1
The twist is that the matches are only to be in the matching
position...ie the example above would only have one match, which
is "D" (A1 and H1)...even though there are four repeated values...
they are not in the matching postion, I am going to have to do this
lots and lots of times down a list. I want to try and do that bit...
Anybody know a fast way to check this?
thanks
ste