Enabling a Timestamp in Excel Upon Cell Modification without Overwriting Existing Timestamps
To achieve this, follow these steps:
Step 1: Enable Iteration in Excel Options
Navigate to Options -> Formula -> Iteration and ensure the option is enabled.
Step 2: Adding Timestamps to Column B on Change in Column C
Suppose your values are in Column C, and you want to track timestamps in Column B. Apply the following formula in Column B:
=IF(C2<>"", IF(B2="", CONCAT(MINUTE(NOW()), ":", SECOND(NOW())), B2), "")
This formula will only update the timestamp in Column B if a change is made in the corresponding cell of Column C, ensuring it doesn't overwrite existing timestamps.
No comments:
Post a Comment