Forum Discussion
2013 doesn't have =filter() function. ANY alternate function?
I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form. In database there is a ...
=IFERROR(INDEX($A$2:$A$23,SMALL(IF($B$2:$B$23>60,ROW($B$2:$B$23)-1),ROW(A1))),"")An alternative could be this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021. The formula filters the values in column A if the corresponding value in column B is greater than 60. The screenshot is taken from Excel 2013.