Horns of a dilemma!
Posted by Richard Larocque on January 31, 2002 5:50 AM
OK! Here's the problem. I have three columns. Column A is labelled Dates, B is labelled Price. What I'm looking to do is as follows: Every day, in Column C1, there will be a new value. I want the price in C1 to go also in column B. So for example, if on Jan.1,(Column A2) the price is 40, I would like the number 40 to appear in Column B2. On Jan.2, (Column A3)the price is 39, the same number appears in B3, and so forth. However, there is a catch! The numbers in the preceding days must remain the same! In B2, the 40 would not change whenever a new number appeared in C1. Can you help?