Hi,

Let's just take your idea and modify it a tad:

=IF(AND(AC136:AC146="Yes"),"Yes","No")

=IF(OR(AC136:AC146="No"),"No","Yes")
(if by flip you mean the cells contain either Yes or No.)

=IF(OR(AC136:AC146<"Yes"),"No","Yes")
(This works like the first one regardless)

all are array entered.


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


" wrote:

I can't get this to work:

{=IF(($AC$136:$AC$146="Yes"),"Yes", "No")}

I want to return the header of data to return Yes once all the details
have been flipped to yes.

Thoughts.