Formula help

G

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
 
B

Bernie Deitrick

George,

In cell J3:

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

HTH,
Bernie
MS Excel MVP
 
G

George Gee

Bernie

That worked for me!

Many thanks

George


*Bernie Deitrick* has posted this message:
 
C

CLR

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

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

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Counting dates in filtered column 1
Copy addition formula of non-consecutive horizontal cells 2
IF Statement on multiple levels 6
Cell Required before Closing 1
Circular Reference 1
Adding cells but leaving blank if not populated 2
Multiple Non-Contiguous Cell Ranges Varying In Length 1

Top