IFERROR(...)
How to retrieve values with only "Yes" in column next to it.
Used Functions
Category: Logical
Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
Syntax
IFERROR(value, value_if_error)
Practice IFERROR Formula at Sheetzoom
IFERROR formula at Microsoft helpCategory: Lookup and reference
Returns a reference offset from a given reference
Syntax
OFFSET(reference, rows, cols, [height], [width])
Category: Statistical
Returns the k-th smallest value in a data set
Syntax
SMALL(array, k)
Category: Logical
Specifies a logical test to perform
Syntax
IF(Something is True, then do something, otherwise do something else)
Category: Lookup and reference
Returns the row number of a reference
Syntax
ROW([reference])
0