| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula too long error message to linked spreadsheet | Links and Linking in Excel | |||
| How do I track changes on an Office 2007 Excel spreadsheet | Excel Discussion (Misc queries) | |||
| How do I track and save changes within an excel spreadsheet among. | Excel Worksheet Functions | |||
| Trying to keep track of updated link data in an excel spreadsheet | Excel Worksheet Functions | |||
| How can I print long lists of data from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
