FILTER function

%3CLINGO-SUB%20id%3D%22lingo-sub-2865423%22%20slang%3D%22en-US%22%3EFILTER%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2865423%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20the%20FILTER%20function%20in%20a%20file%20on%20my%20computer%20that%20has%20Excel%20365%20but%20I%20also%20wanna%20run%20that%20same%20file%20on%20my%20tablet%20that%20has%20Excel%202016.%20However%2C%20the%20FILTER%20function%20is%20unavailable%20in%20Excel%202016%20so%20I%20was%20wondering%20if%20there%20was%20another%20function%20that%20I%20could%20use%20to%20replace%20the%20FILTER%20function.%20Thank%20you%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2865423%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

 

1 Reply
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.