title: excel function to find last number in column
body: <p>I record the value of my stocks each day in columns and it is a long spreadsheet.  In the top cell of each column, I want to use a function that will display the last entry in the column automatically.  I've tried the Index function and the Index function combined with the Counta function with no success.  Any suggestions?</p>