How do I change a cell reference every time there is a blank cell?

  • Thread starter Thread starter Read
  • Start date Start date
I am trying to copy a cell value in Column A to Column B. I want to stop the
copy at a blank row and start the formula over referencing the new dataset.
Example:
Column A Column B
bread bread
943234 bread
234112 bread

milk milk
232134 milk
123134 milk

Everything I have tried moves bread down the Entire ColumnB
 
Assuming your data starts in A1, in B1:

=A1

In B2:

=IF(A2="","",IF(A1="",A2,B1))

and copy down.
 
Excel says that formula creates a circular reference. Basically I need b1,b2
and b3 to say bread and b5,b6 and b7 to say milk. When I make the a formula
absolute and drag it down column b the entire column =bread. I need a formula
to recognize tht a4 or b4 is blank and reference a5 instead of a1 for the
next data set. Any advice?
 
Did you put my exact formulas in the exact cells I recommended? If not, let me
know where you put them because they need to be adjusted properly.
 
You must log in or register to reply here.

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

How to reference last non-blank cell value from a column cells? 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Blank Cells vs. Zero Values 2
How to return a blank formula cell if the reference is blank? 2
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
How do I get Rid of the Circumflex Accent (Caret) 2
row number of last non-blank cell 14
change cell event using circular reference - not VBA! 3

Back
Top