Can anyone help. I've got a stock control spreadsheet where a new row is
entered when the stock position changes. Column D has the stock position.
Below the row showing the latest stock position are empty rows for future
At the bottom of the table, below the empty rows, is a cell in Column D
where I want to report the latest stock figure.
Is there a way to do it that isn't upset by those empty cells.
Sample data and outcome would typically look like
Day 1 25
Day 2 33
Day 3 11
Curr Stock 11
Make your own search :
Copyright © 2001-2013 GNT Media