Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if isblank question
Good day,
Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be replaced in the formula to the right of the column...?? for example, a b 1 1 1 1 2 2 2 2 and so on....?? Kind regards -- Thanks for your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if isblank question
In B1:
=A1 In B2: =IF(A2="",B1,A2) and copy down This is the same as an ISBLANK test -- Gary''s Student - gsnu200792 "TamIam" wrote: Good day, Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be replaced in the formula to the right of the column...?? for example, a b 1 1 1 1 2 2 2 2 and so on....?? Kind regards -- Thanks for your help! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if isblank question
This works for the second row, but thereafter displays a blank...any
suggestions? -- Thanks for your help! "Gary''s Student" wrote: In B1: =A1 In B2: =IF(A2="",B1,A2) and copy down This is the same as an ISBLANK test -- Gary''s Student - gsnu200792 "TamIam" wrote: Good day, Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be replaced in the formula to the right of the column...?? for example, a b 1 1 1 1 2 2 2 2 and so on....?? Kind regards -- Thanks for your help! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if isblank question
[Off Topic for this Thread]
Message to Gary''s Student... In case you were not planning on revisiting your "Same Contents, Regardless of Order" thread over in the m.p.e.programming newsgroup, I posted a message there that I think you should read. Rick "Gary''s Student" wrote in message ... In B1: =A1 In B2: =IF(A2="",B1,A2) and copy down This is the same as an ISBLANK test -- Gary''s Student - gsnu200792 "TamIam" wrote: Good day, Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be replaced in the formula to the right of the column...?? for example, a b 1 1 1 1 2 2 2 2 and so on....?? Kind regards -- Thanks for your help! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if isblank question
Make sure that calculation is set to Automatic
Make sure the formulas are adjusting as you copy downward in column B. Column B should look like: =A1 =IF(A2="",B1,A2) =IF(A3="",B2,A3) =IF(A4="",B3,A4) =IF(A5="",B4,A5) =IF(A6="",B5,A6) =IF(A7="",B6,A7) =IF(A8="",B7,A8) =IF(A9="",B8,A9) =IF(A10="",B9,A10) Also make sure the "blank" values in column A are REALLY blanks and not single spaces. -- Gary''s Student - gsnu200792 "TamIam" wrote: This works for the second row, but thereafter displays a blank...any suggestions? -- Thanks for your help! "Gary''s Student" wrote: In B1: =A1 In B2: =IF(A2="",B1,A2) and copy down This is the same as an ISBLANK test -- Gary''s Student - gsnu200792 "TamIam" wrote: Good day, Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be replaced in the formula to the right of the column...?? for example, a b 1 1 1 1 2 2 2 2 and so on....?? Kind regards -- Thanks for your help! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if isblank question
Thanks....I will check it out right now.
-- Gary''s Student - gsnu200792 "Rick Rothstein (MVP - VB)" wrote: [Off Topic for this Thread] Message to Gary''s Student... In case you were not planning on revisiting your "Same Contents, Regardless of Order" thread over in the m.p.e.programming newsgroup, I posted a message there that I think you should read. Rick "Gary''s Student" wrote in message ... In B1: =A1 In B2: =IF(A2="",B1,A2) and copy down This is the same as an ISBLANK test -- Gary''s Student - gsnu200792 "TamIam" wrote: Good day, Would anyone know of a way to include the if(isblank()) in reference to a column with every fourth cell populated with a value that needs to be replaced in the formula to the right of the column...?? for example, a b 1 1 1 1 2 2 2 2 and so on....?? Kind regards -- Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF AND ISBLANK | Excel Worksheet Functions | |||
ISBLANK() | Excel Worksheet Functions | |||
IF(ISBLANK question | Excel Worksheet Functions | |||
isBlank() | Excel Worksheet Functions | |||
ISBLANK | Excel Worksheet Functions |