Support Board
Date/Time: Sun, 22 Dec 2024 16:13:47 +0000
Post From: help with spreadsheet formula
| [2015-02-09 22:36:02] |
| jivetrader - Posts: 410 |
|
using SC spreadsheets (not Excel) let's say column K has an unknown number of rows of "TRUE" followed by an unknown number of rows of "FALSE", and this repeats ad infinitum. e.g. TRUE TRUE TRUE TRUE TRUE FALSE FALSE FALSE TRUE TRUE . . . how to find the row of the most recent FALSE (row 6 in the above example)? TIA |