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.netwrote:
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.
ABC
2 35
6 9
8 11
4 2 6
15 17
8 10
21829
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