Returning Value of Next Non-Blank Cell in Column

M

Monk

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Having Blank Cells, etc. ? 1
First non empty cell and non blank cell 6
Return value in non-blank cell 3
Find previous number and find next number in column 4
Return value of non-blank cell 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1

Top