I have a spreadsheet set up with pricing from vendors. Here is my goal to
achieve if possible but I am not sure since I just know the basics.
Example: (this is how I have it setup now)
Description Date Price
Widget A 9/25/05 $0.04
Widget B 8/20/05 $0.75
Widget C 9/25/05 $0.15
Example: (this is how I want it to look after the fact)
Description Date Price Last Date Old Price Change %
Change
Widget A 9/30/05 $0.06 9/25/05 $0.04 +$0.02
+50.0%
Widget B 9/30/05 $0.75 8/20/05
- -
Widget C 9/30/05 $0.11 9/25/05
5 -$0.04 -26.6%
I only want to key new information into the Date cell and Price cell and
have it move what was in the prior to that to the Last Date cell and the Old
Price cell.
If this possible?
Please help,
Thanks,
Carl
Bookmarks