View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The Stoat The Stoat is offline
external usenet poster
 
Posts: 3
Default Finding most recently entered number within a column

Hi,

Does anyone know how to find the most recently entered number within a
column and apply to a calculation?

I have a spreadsheet that has an extra row added every week, so the most
recently added figures are not in the same cells for the formula.

Another way would be to find the lowest visual number (as opposed to lowest
numerically) within a column.

Hope this makes sense!

Thanks for any help,

Matt.