Excel Formula Help
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 |
Excel Formula Help
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 |
Excel Formula Help
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 --- |
Excel Formula Help
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 --- |
Excel Formula Help
=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 |
Excel Formula Help
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 --- |
Excel Formula Help
"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 --- |
All times are GMT +1. The time now is 02:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com