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

This tinker seems to work ok
Source data as posted in A1 down
In B1: =A1
In C1: =IF(A2="","",IF(ISNUMBER(A2),C1,A2))
Copy C1 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"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

Errata, sorry:
In C1: =IF(A2="","",IF(ISNUMBER(A2),C1,A2))
Copy C1 down

Should be:
In B2: =IF(A2="","",IF(ISNUMBER(A2),B1,A2))
Copy B2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

This formula copied down column B makes an entire column of bread. It never
recognizes the change to milk? I'm still confused?

"Max" wrote:

Errata, sorry:
In C1: =IF(A2="","",IF(ISNUMBER(A2),C1,A2))
Copy C1 down

Should be:
In B2: =IF(A2="","",IF(ISNUMBER(A2),B1,A2))
Copy B2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

=IF(A1="","",LOOKUP(REPT("z",255),$A$1:A1))


"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

Is calculation set to Automatic?


Gord Dibben MS Excel MVP

On Wed, 10 Dec 2008 05:42:05 -0800, Read
wrote:

This formula copied down column B makes an entire column of bread. It never
recognizes the change to milk? I'm still confused?

"Max" wrote:

Errata, sorry:
In C1: =IF(A2="","",IF(ISNUMBER(A2),C1,A2))
Copy C1 down

Should be:
In B2: =IF(A2="","",IF(ISNUMBER(A2),B1,A2))
Copy B2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---

"Read" wrote:
This formula copied down column B makes an entire column of bread. It never
recognizes the change to milk? I'm still confused?

How about a quick working sample to take-away & unravel it all?
Should help give clarity:
http://freefilehosting.net/download/42m1h
Read.xls

(Sample also contains TM's neater, single formula solution)

There you go. Do remember to press the YES buttons (like the one below) in
ALL responses which helped you in this thread, won't you?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---