View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default writing a formula in Excel spreadsheet to track how long data has

What DB?

If you mean ***continuous data*** in Excel starting from cell A1; the below
formula will give you the cell reference of the last filled cell (assuming
ColA is a mandatory field)

=ADDRESS(COUNTA(A:A),1)

--
Jacob


"flyboy719" wrote:

I could use some assistance in finding out if there is a way to write a
formula in Excel to track how long data has been entered into a database