KarenABS;226956 Wrote:
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.

"Mike H" wrote:

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" wrote:

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

in A1 try =if(istext(c1),e1,"")


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=63068