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:
=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!
Bookmarks