Using function on column?
 

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

Using function on column?
 

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

Using function on column?
 

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

Using function on column?
 

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