Hi Steve, An alternative for your query without using an Logical formula is attached. Procedure is as under:
1. Select Column B and do "Go To Special" option (i.e., Keyboard shortcut F5 or Ctrl+G and select Special Tab) 2. Choose the option "Blanks" 3. Now type"=B1" in cell B2 and press "Ctrl+Enter"... Alas,all the gaps will be filled with the required value . Thanks Vinod On Sat, Aug 28, 2010 at 1:13 PM, xsrossiter <steverossi...@sbcglobal.net>wrote: > Hello, > > I am using Excel 2002 SP3 and hope to find a conditional solution > using formulas rather than a macro. In column A are a series of > values, column B has values at irregular intervals, and column C > contains calculated values based on a value in column B until a new > value in column B is encountered and then it incorporates the new > column B value in its calculation. > > A B C > 2 3 5 > 6 9 > 8 11 > 4 2 6 > 15 17 > 8 10 > 21 8 29 > > For example, column C contains a formula to sum columns A and B. It > adds 3 to whatever value is in column A until the fourth row at which > point it adds 2 to whatever value is in the A column and finally as it > gets to the seventh row begins adding 8 to A column values. > > Is there some formula that can be placed in column C that will follow > this logic and avoid using a macro? Column A at this point has 86 rows > and column B has 14 values at varying intervals. > > Thanks for your help and time. > > Steve > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks and Regards Vinod N http://cavinod.blogspot.com/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Ctrl_g_Vinod.xls
Description: MS-Excel spreadsheet