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

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
 
B

Bob Phillips

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
 
J

Jacob Skaria

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top