| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning Value of Next Non-Blank Cell in Column
cI have data in three columns. Values in Column A are calculated by an if
statement and are summed and return a value in Column B, with blank fields appearing in the adjacent rows to the column A data. Is there a formula that will allow for those blank cells to return the value of the next non-blank cell (perhaps detailed in Column C?) Any thoughts would be appreciated. A B C (peferred output) 3.2 Blank 8.6 5.4 Blank 8.6 8.6 8.6 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning Value of Next Non-Blank Cell in Column
In C1 enter:
=IF(B1="",C2,B1) and copy down -- Gary''s Student - gsnu200776 "Monk" wrote: cI have data in three columns. Values in Column A are calculated by an if statement and are summed and return a value in Column B, with blank fields appearing in the adjacent rows to the column A data. Is there a formula that will allow for those blank cells to return the value of the next non-blank cell (perhaps detailed in Column C?) Any thoughts would be appreciated. A B C (peferred output) 3.2 Blank 8.6 5.4 Blank 8.6 8.6 8.6 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Returning Value of Next Non-Blank Cell in Column
Thanks. Solve's my dilemma. Thought it would be more difficult.
"Gary''s Student" wrote: In C1 enter: =IF(B1="",C2,B1) and copy down -- Gary''s Student - gsnu200776 "Monk" wrote: cI have data in three columns. Values in Column A are calculated by an if statement and are summed and return a value in Column B, with blank fields appearing in the adjacent rows to the column A data. Is there a formula that will allow for those blank cells to return the value of the next non-blank cell (perhaps detailed in Column C?) Any thoughts would be appreciated. A B C (peferred output) 3.2 Blank 8.6 5.4 Blank 8.6 8.6 8.6 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning blank cell when conditions not met | Excel Worksheet Functions | |||
| Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
| returning blank cell | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
| Formulas returning a blank if no data entered in one cell | New Users to Excel | |||
![Monk[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
