Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LookUp Function with Two Column Search Returning One Column Value | Excel Worksheet Functions | |||
Set whole column with function | Excel Discussion (Misc queries) | |||
How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
MAX Function and Corresponding Column | Excel Discussion (Misc queries) |