I have a column of numbers that fills in when certain other conditions are met. I want to be able to display the last entry in that column in another area of the worksheet. So for example if 12 cells are in a column and as condtions are met, the cell below the last will fill in. I want that last cell with a value to display in another cell(call it D1), so D1 will update as each new entry is filled in the column.
Either I left my brain at home today or this is not as easy as it sounds. Any help?

I have two ideas:

1. When the cell fills in (when your other conditions are met), in addition to filling in the cell, your conditional can also increment an address cell which is somewhere else. You use this address cell in your other location to figure out where your data is.

2. Use a delimiting value on your column, like "END", or something -- doesn't matter. Then, when your conditions are met, the next column value is written, as well as the delimiter in the next row of that column. Your display area, elsewhere in the page, can look for the END using a conditional, and display the results of the row above it.

There may be better ways with newer versions of Excel. My hard-core Excel days are a ways back...

FWIW,
Jim