$$Excel-Macros$$ Re: Calculation based on changing conditions

2010-08-29 Thread xsrossiter
Thank you both, Michael and Vinod N, for these helpful solutions, Steve. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

$$Excel-Macros$$ Calculation based on changing conditions

2010-08-28 Thread xsrossiter
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