What function can I use in Excel 2019 in lieu of Google Sheets 'FILTER'?-CodePudding

I would like the cells on sheet MATRIX from A5 to A120000 to display the dates on sheet ALGORITHM only if the corresponding column C on ALGORITHM is defined as TRUE

I have used the Google Sheets formula FILTER however I do not have that function in my version (2019) of Excel.

Would anyone be able to suggest an alternative to FILTER and a recommended formula?

CodePudding user response：

So, here is a quick example of the formula given in above comments,

• Formula used in cell D2

=IFERROR(INDEX($A$2:$A$15,AGGREGATE(15,6,(ROW($B$2:$B$15)-ROW($B$2) 1)/($B$2:$B$15=TRUE),ROW(A1))),"")

And Fill Down !