List header columns.

[Tom.Jones]

List header columns.

In Sheet 1 there are 3 columns (say C, D and E). In each row, starting with row 2, there are 3 items, usually identical. What formula should be used, so if the 3 items in a row are the same then the formula returns "YES". If one of the cells is a different item, then list the header for the column in row 1. All items in columns C, D and E are the result of some formulas. So, there may be empty cells (""), or cells with errors.

Col C..........Col D............Col E
Header1.....Header2......Header3
AA..............AA................AA.................YES
DD..............(empty)........DD..................Header2
MM.............MM..............TT...................Header3
MM.............#N/A...........MM.................Header2
KK...............KK...............KK....................YES
................
................

Thanks.

 

[Marcelo Branco]

Maybe...

F2 copied down
=IFERROR(INDEX(C$1:E$1,MATCH(1,INDEX(--(COUNTIF(C2:E2,C2:E2&"")=1),0),0)),"Yes")

M.

 

[Tom.Jones]

Excellent, excellent.

Thank you Marcelo.

 

[Marcelo Branco]

You're welcome. Glad to help.

M.