Support Board
Date/Time: Sun, 02 Nov 2025 11:39:29 +0000
Post From: Spreadsheet programming - locking one time event
| [2020-04-07 19:11:13] |
| User183724 - Posts: 194 |
|
need to save (freeze) a copy of current line 3 of the [ID0.SG1] Open [ID0.SG2] High [ID0.SG3] Low [ID0.SG4] Last when K3 or M3 go from 0 to 1. Don't need to keep after K3/M3 return to 0. could use the same area to store the next occurrence. I'm working with this Locking the State of a One Time Condition Spreadsheet Studies Special Tasks and this Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables Persistent and Incrementing Variables can't quite get it to work and reset correctly. any assistance appreciated. thx tim |