ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   writing a formula in Excel spreadsheet to track how long data has (https://www.excelbanter.com/excel-worksheet-functions/253857-writing-formula-excel-spreadsheet-track-how-long-data-has.html)

flyboy719

writing a formula in Excel spreadsheet to track how long data has
 
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

Bob Phillips[_4_]

writing a formula in Excel spreadsheet to track how long data has
 
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

"flyboy719" wrote in message
...
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




Jacob Skaria

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



All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com