writing a formula in Excel spreadsheet to track how long data has

  • Thread starter Thread starter flyboy719
  • Start date Start date
F

flyboy719

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
 
What sort of database? What are the rules for determining 'how long'? you
need to properly state your requirement if you want a useful response.

HTH

Bob
 
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)
 
Back
Top