FILTER function

[Gabrielle3401]

Hi! 

I am using the FILTER function in a file on my computer that has Excel 365 but I also wanna run that same file on my tablet that has Excel 2016. However, the FILTER function is unavailable in Excel 2016 so I was wondering if there was another function that I could use to replace the FILTER function. Thank you :)

[#2]

No there is no direct replacement for FILTER() but not to say whatever you are using FILTER to do couldn't be done using other functions. It all depends on what/how you are using that function.