Support Board
Date/Time: Sun, 06 Jul 2025 15:31:19 +0000
Post From: Getting a #value! error...
| [2019-03-22 23:05:04] |
| Sawtooth - Posts: 4236 |
|
If the signals appear as 1 in the cells, you could use a formula like this: =AND(SUM(OFFSET(ID25.SG1@4,0,0,26,1))=26,SUM(OFFSET(ID51.SG1@4,0,0,26,1))=26,SUM(OFFSET(ID68.SG1@4,0,0,26,1))=26) This will be TRUE even if there are more than 26 in a row. |