Support Board
Date/Time: Sun, 24 Nov 2024 16:07:07 +0000
Post From: Permanent/ Static Counter on Spreadsheet
| [2024-05-24 06:14:26] |
| alexo2022 - Posts: 47 |
|
Try this: Put this in e.g. S3: =IF(S4=10,0,S4+1) This will count from 0 to 10, and repeat. P3: =IF(S3=2,P4+1,P4) This will increment the count by 1 each time there is a 2 in column S, and make it persistent until the next 2. it works as long as the numbers are in the spreadsheet, there are 1000 rows in my spreadsheet, once the number "2" is getting out of the spreadsheet, the counter resets. I need counter in other cell that has "memory", that can save the counting even though the numbers are no longer there. For example first time - Q3=2 -> Count 1 second time - Q3=2 -> Count 2 third time - Q3=2 -> Count 3 etc |