Formula help

[George Gee]

Hi all

How can I express this as a formula:

In J3:

If any cell in the range C5:H5 contains "a", then J3 contains "a"

Cells C5:H5 contain only "a", or are blank.

Many thanks


George

 

[Bernie Deitrick]

George,

In cell J3:

=IF(COUNTIF(C5:H5,"a")>0,"a","")

HTH,
Bernie
MS Excel MVP

 

[George Gee]

Bernie

That worked for me!

Many thanks

George


*Bernie Deitrick* has posted this message:

 

[CLR]

A few strokes shorter.............

=LEFT(C5&D5&E5&F5&G5&H5,1)

Vaya con Dios,
Chuck, CABGx3