Find match in the same columns

[Kishan]

Using Excel 2000

Hi,

My data are finding in row 6 to 11 I want formula result in the row 13…

Need formula match only (1) of row 6 and 11 if match are the same in the column.... result 1, if not result No all other must be empty in the result row 13

Here is example sheet.

1X2-Analisis 14 x 14 (1's) Grid v1.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
4
5
6		A	1	1	1	99	1	12	1	22	K	1	1	M	1
7		B	C	49	1	L	D	1	1	11	1	G	71	1	1
8		Q	1	H	69	1	65	P	K	P	1	1	1	H	Z
9		1	1	F	1	45	1	K	1	1	1	50	1	P	1
10		1	1	1	1	1	D	1	1	1	58	92	G	1	1
11		T	1	1	H	P	1	1	1	1	73	1	1	L	V
12
13	1's Match Result--->		1	1	No		1	No	1			1	1		1
14
Sheet15

Thank you in advance

Regards,
Kishan

 

[Cubist]

Why does column I return "No" and K return empty?

Also why column P return 1, when only match in row 6 and not 11?

 

[Kishan]

Hi Cubist, the result are ok I am comaiping row 6 againest 11

 

[Kishan]

Hi Cubist, the result are ok I am comaiping row 6 againest 11

Hi Cubist, Please ignore post#3, sorry it is my mistake.

Also why column P return 1, when only match in row 6 and not 11?

As I want to comparing row 6 against 11 in this case this this should be the correct result.

1X2-Analisis 14 x 14 (1's) Grid v1.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
5
6		A	1	1	1	99	1	12	1	22	K	1	1	M	1
7		B	C	49	1	L	D	1	1	11	1	G	71	1	1
8		Q	1	H	69	1	65	P	K	P	1	1	1	H	Z
9		1	1	F	1	45	1	K	1	1	1	50	1	P	1
10		1	1	1	1	1	D	1	1	1	58	92	G	1	1
11		T	1	1	H	P	1	1	1	1	73	1	1	L	V
12
13	1's Match Result--->		1	1	No		1		1			1	1		No
14
Sheet15

 

[Scott Huish]

=IF(AND(C6=1,C6=C11),1,IF(C6=1,"NO",""))

Copy across.

Book2
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
6		A	1	1	1	99	1	12	1	22	K	1	1	M	1
7		B	C	49	1	L	D	1	1	11	1	G	71	1	1
8		Q	1	H	69	1	65	P	K	P	1	1	1	H	Z
9		1	1	F	1	45	1	K	1	1	1	50	1	P	1
10		1	1	1	1	1	D	1	1	1	58	92	G	1	1
11		T	1	1	H	P	1	1	1	1	73	1	1	L	V
12
13
14
15	1's Match Result--->		1	1	NO		1		1			1	1		NO
Sheet1

Cell Formulas
Range	Formula
C15:P15	C15	=IF(AND(C6=1,C6=C11),1,IF(C6=1,"NO",""))

 

[Kishan]

=IF(AND(C6=1,C6=C11),1,IF(C6=1,"NO",""))
Copy across.

Hi Scott Huish,​

Formula work as request. Thank you very much for your help!

Have a nice time and great Sunday.

Kind regards,
Kishan