Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
I need to automatically date stamp a two column entry and retain the date.
The formula in column C could be =IF(AND(A10,B1=0),TODAY(),NOCHANGE) This would result in the date appearing in column C when an entry is made in A1 and the date holding when an entry is made in B1 - how simple. Except there isn't a function like NOCHANGE available. (this would also be the perfect solution for killing circular references and reiterations in a single cell) So, can anbody please advise how I can achieve the same result from a formula using the available functions in Excel? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
I'm afraid you cannot solve this tasks with formulae, you have to create a
Change event macro for it! Regards, Stefi Ron@Buy ezt *rta: I need to automatically date stamp a two column entry and retain the date. The formula in column C could be =IF(AND(A10,B1=0),TODAY(),NOCHANGE) This would result in the date appearing in column C when an entry is made in A1 and the date holding when an entry is made in B1 - how simple. Except there isn't a function like NOCHANGE available. (this would also be the perfect solution for killing circular references and reiterations in a single cell) So, can anbody please advise how I can achieve the same result from a formula using the available functions in Excel? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
Thanks for your prompt response Stefi, I might have guessed. I was using the
suggested formula over 15 years ago in a DOS based fully integrated (word processor, database & spreadsheet) software program. Perhaps Microsoft will catch up one day !!! Regards Ron "Stefi" wrote: I'm afraid you cannot solve this tasks with formulae, you have to create a Change event macro for it! Regards, Stefi Ron@Buy ezt *rta: I need to automatically date stamp a two column entry and retain the date. The formula in column C could be =IF(AND(A10,B1=0),TODAY(),NOCHANGE) This would result in the date appearing in column C when an entry is made in A1 and the date holding when an entry is made in B1 - how simple. Except there isn't a function like NOCHANGE available. (this would also be the perfect solution for killing circular references and reiterations in a single cell) So, can anbody please advise how I can achieve the same result from a formula using the available functions in Excel? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
Yes, there are several points in MS software requiring improvement. Sometimes
I feel MS makes desperate efforts to develop spectacular but not really necessary features and neglects small but useful ones. Regards, Stefi Ron@Buy ezt *rta: Thanks for your prompt response Stefi, I might have guessed. I was using the suggested formula over 15 years ago in a DOS based fully integrated (word processor, database & spreadsheet) software program. Perhaps Microsoft will catch up one day !!! Regards Ron "Stefi" wrote: I'm afraid you cannot solve this tasks with formulae, you have to create a Change event macro for it! Regards, Stefi Ron@Buy ezt *rta: I need to automatically date stamp a two column entry and retain the date. The formula in column C could be =IF(AND(A10,B1=0),TODAY(),NOCHANGE) This would result in the date appearing in column C when an entry is made in A1 and the date holding when an entry is made in B1 - how simple. Except there isn't a function like NOCHANGE available. (this would also be the perfect solution for killing circular references and reiterations in a single cell) So, can anbody please advise how I can achieve the same result from a formula using the available functions in Excel? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
For one way, see
http://www.mcgimpsey.com/excel/timestamp.html In article , Ron@Buy wrote: So, can anbody please advise how I can achieve the same result from a formula using the available functions in Excel? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
No, you don't. See
http://www.mcgimpsey.com/excel/timestamp.html for one alternative using worksheet functions. In article , Stefi wrote: I'm afraid you cannot solve this tasks with formulae, you have to create a Change event macro for it! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple problem, simple formula, no FUNCTION !
Thank you
Seems to work OK apart from the circular reference which I can live with, oh and I note that the cell with the formula should be locked as clicking on it can drop the date! Once again Thanks "JE McGimpsey" wrote: No, you don't. See http://www.mcgimpsey.com/excel/timestamp.html for one alternative using worksheet functions. In article , Stefi wrote: I'm afraid you cannot solve this tasks with formulae, you have to create a Change event macro for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple formula problem | Excel Discussion (Misc queries) | |||
Simple function problem | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Function formula for simple worksheet | New Users to Excel | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |