Using Excel2000
Hi,
I want tocheck row 10 data and find match, comparing with Row 6 & 7
Examplebelow shows 10 matches found in the row 10 what formula could be to apply tofind match in the cell R10?
Thank youin advance
Regards,
Kishan
Hi,
I want tocheck row 10 data and find match, comparing with Row 6 & 7
Examplebelow shows 10 matches found in the row 10 what formula could be to apply tofind match in the cell R10?
Book1 | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | |||||||||||||||||||||
2 | |||||||||||||||||||||
3 | |||||||||||||||||||||
4 | |||||||||||||||||||||
5 | |||||||||||||||||||||
6 | 2 | 1 | 1 | 1 | X | X | 1 | X | X | 1 | 1 | 1 | 2 | X | |||||||
7 | X | 2 | 1 | 2 | 2 | X | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 1 | |||||||
8 | |||||||||||||||||||||
9 | |||||||||||||||||||||
10 | 2 | 1 | 1 | X | 2 | 1 | 1 | X | 2 | X | 2 | 2 | 2 | X | 10 | ||||||
11 | |||||||||||||||||||||
12 | |||||||||||||||||||||
Sheet1 |
Thank youin advance
Regards,
Kishan
Last edited: