Hi Experts, in Google sheets the filter function/formula is easy to use. Am using it for months now.
I was expecting the same in Excel. However, the Excel that we are using doesn't has the filter function. The function we found with filter in it's name is FilterXML.
Excel is being used for a remote production area. So no access to internet.
What formula alternatives are there? Or how can I find a formula like filter in Excel?