View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Victor Delta Victor Delta is offline
external usenet poster
 
Posts: 2
Default Last entry in a column/row function?

I have several spreadsheets which I use for data gathering (usually in
columns, but could be in rows) and where I need to do calculations
based on the last (ie most recent, at the bottom) entry in the column.

Although Excel has functions designed to help me find the largest,
smallest, average etc etc of these numbers, I have yet to find one
which returns the last entry. Of course, it is not hard to add an extra
(subsequently hidden) column which does the calculations (using the if
and isblank functions) but I'm sure there must be a better way to do it
- with a formula in a single cell.

Any suggestions please?

Thanks

V