if row contains

[puuts]

Hi,

can you help me with this.

I just want if "O11" to "the end of the row" contains "On Queue" Row D11 will be "C" else "UC".

I've attached the output.

[AYData]

=IF($O:$O="On Queue", "C","UC")

Drag down as far as required in Col D

[puuts]

Hi AYData, how about for vba?

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.