I have a column of prices from my Easter Flowers. An Example: Column A Prices are arranged as 376 384 386 389 387 384 381 384 386 393 390 389 386 389 etc.
EXCEL needs to subtract the first two 376-384 which is a difference of +7. Now in Column B I need Excel to populate cells with the continuous numbers of 376,377,378,379,380,381,382,383,384.
The next is 384-386 which is +2 number. Now in Column B again it needs to continue count from 385,386.
The next is 386-389 which is +3 units higher. Now in Column B it needs to continue count 387,388,389
The next is 389-387 which is -2 units lower. Now in Column B it needs to count 388,387. It needs to be dynamic and continue automatic counting in Column B whether plus or minus as Column A live feed adds another new daily PRICE. If there are double HIGHS or LOWS then COLUMN B should advance 1 cell but the Price would remain the same.
REVIEW of the end result of my Easter Flowers prices in Column A would dynamically create in Column B the following PRICE result string of : 376,377,378,379,380,381,382,383,384,385,386,387,388,389,388,387,386,385,384,385,386,387,388,389,390,391,392,393,392,391,390,389,388,387,386,387,388,389 etc. This should be simple to construct but I am relatively new to excel so I would like professional help for this formula.
EXCEL needs to subtract the first two 376-384 which is a difference of +7. Now in Column B I need Excel to populate cells with the continuous numbers of 376,377,378,379,380,381,382,383,384.
The next is 384-386 which is +2 number. Now in Column B again it needs to continue count from 385,386.
The next is 386-389 which is +3 units higher. Now in Column B it needs to continue count 387,388,389
The next is 389-387 which is -2 units lower. Now in Column B it needs to count 388,387. It needs to be dynamic and continue automatic counting in Column B whether plus or minus as Column A live feed adds another new daily PRICE. If there are double HIGHS or LOWS then COLUMN B should advance 1 cell but the Price would remain the same.
REVIEW of the end result of my Easter Flowers prices in Column A would dynamically create in Column B the following PRICE result string of : 376,377,378,379,380,381,382,383,384,385,386,387,388,389,388,387,386,385,384,385,386,387,388,389,390,391,392,393,392,391,390,389,388,387,386,387,388,389 etc. This should be simple to construct but I am relatively new to excel so I would like professional help for this formula.
