Copy cell content based on the number of times it is repeated in a row

[lai_arceo]

Good day.

I kindly ask for assistance in figuring out how to copy the content of a cell based on the referenced column and the number of times it is repeated in a row. Attached is what I want to find out.

I want to refer to columns REF 3 in the worksheet. If the cell content is repeated 5 times, it is then copied to the SUMMARY column.

Any help is appreciated.

 

[Eric W]

Try:

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	REF 1	REF 2	REF 3	REF 1	REF 2	REF 3	REF 1	REF 2	REF 3	REF 1	REF 2	REF 3	REF 1	REF 2	REF 3	SUMMARY
2	red	blue	pink	red	red	pink	red	blue	pink	pink	red	pink	pink	blue	pink	pink
3	blue	blue	red	blue	blue	red	red	red	blue	blue	blue	blue	blue	blue	blue
Sheet4

Cell Formulas
Range	Formula
P2:P3	P2	=IF(SUMPRODUCT((A$1:O$1="REF 3")*(A2:O2=C2))=5,C2,"")

 

[lai_arceo]

=IF(SUMPRODUCT((A$1:O$1="REF 3")*(A2:O2=C2))=5,C2,"")

This worked perfectly! Thank you so much!

 

[Eric W]

Happy to help! Thanks for the feedback.