George,

In cell J3:

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

HTH,
Bernie
MS Excel MVP

"George Gee" wrote in message
...
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