Please enable JavaScript to view the comments powered by Disqus.


IFERROR(...OFFSET(...$A$1,SMALL(...IF(...$B$2:$B$11="Yes",ROW(...$B$2:$B$11),"..."),ROW(...A1))-1,0),"")

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)

Category: 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])

Lets chat on this