andrew_milonavic
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 98
Hi,
If I have a formula in A1, is it possible to have a formula in B1 that would tell me the date A1 changed? So if A1 was Cat and the workbook/sheet recalculated and A1 stayed cat then the date in B1 wouldn't change. If A1 changed from cat to dog, or anything other than cat, then B1's date would update.
Possible?
Thanks
Andrew
If I have a formula in A1, is it possible to have a formula in B1 that would tell me the date A1 changed? So if A1 was Cat and the workbook/sheet recalculated and A1 stayed cat then the date in B1 wouldn't change. If A1 changed from cat to dog, or anything other than cat, then B1's date would update.
Possible?
Thanks
Andrew