Support Board
Date/Time: Sun, 02 Nov 2025 19:22:17 +0000
Post From: Index and Match on spreadsheet
| [2015-01-01 21:48:43] |
| Sawtooth - Posts: 4285 |
|
Here's a workaround, using another Formula Column, e.g. P: cell P3: =IF(O3>0,1,0) then: =INDEX(O4:O36,MATCH(1,P4:P36,0),1) |
