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

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

Reference to what? are you using a formula? if so what is it?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39068

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

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

"Simon Lloyd" wrote:


Reference to what? are you using a formula? if so what is it?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39068

How do I change a cell reference every time there is a blankc
 

Assuming your data starts in A1, in B1:

=A1

In B2:

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

and copy down.


Read wrote:
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

"Simon Lloyd" wrote:

Reference to what? are you using a formula? if so what is it?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39068

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

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?

"Glenn" wrote:

Assuming your data starts in A1, in B1:

=A1

In B2:

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

and copy down.


Read wrote:
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

"Simon Lloyd" wrote:

Reference to what? are you using a formula? if so what is it?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39068

How do I change a cell reference every time there is a blankc
 

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.

Read wrote:
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?

"Glenn" wrote:

Assuming your data starts in A1, in B1:

=A1

In B2:

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

and copy down.


Read wrote:
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

"Simon Lloyd" wrote:

Reference to what? are you using a formula? if so what is it?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=39068