I have price sheet dumped from SAP, which gives prices for a given item by
period. If no activity in a period, cell is blank. How do I get a formula to
return the first value in a row(left-most) (of 6 cells) in one cell, and then
the last value (right-most) in another? Represents old price, and last price.