Good morning,

I have this array formula that returns values from one table that contains blank rows (named CRSdata) into a new one without blanks:

Formula: copy to clipboard
=IFERROR(INDEX(CRSdata, SMALL(IF(FREQUENCY(IF(CRSdata<>"", MATCH(ROW(CRSdata), ROW(CRSdata)), ""),
MATCH(ROW(CRSdata), ROW(CRSdata)))>0, MATCH(ROW(CRSdata), ROW(CRSdata)), ""), ROW(A1)), COLUMN(A1)), "")


I need to enhance it to skip not only the blank rows, but also the rows in which the values in column G are TRUE.

I will be eternally grateful to anyone able to solve this conundrum!