Using function on column?

[KarenABS]

I am using this function =IF(ISBLANK($C8),($E8),($E8)) on individual cells
and it is working fine. My issue is when refreshing the data I won't know
how many cells will need the function. Can I use a similar function on an
entire column?
Thanks, Karen

 

[Mike H]

Hi,

I'm afraid the formula you are using as an example doesn't make sense
becuase it returns E8 for both tru and false. You could apply a logical test
to en entire column

=IF(COUNTA(C:C)=0,E8,F8)

But note iv'e made it returns different references for true (E8) and false
(F8)

Mike

 

[KarenABS]

It is supposed to be if text is in column C then I need column A to have the
same value as E. If it is not text then it should not copy...I must not have
had any non text.