Flag rows with formula
Flag rows from the dataset based on the result of a formula by creating a column containing ‘1’ for all matching (in-range) rows. Unmatched rows are left empty.
Options
Expression
Write a formula by which to evaluate each row for a match. The row matches if the result of the formula is considered as “truish,” which includes:
-
A true boolean
-
A number (integer or decimal) that is not 0
-
The string “true”
Flag column
Name the column that will contain the match flags 1-true, empty-false