Forum Discussion
heshamsheeha
Jun 05, 2020Copper Contributor
I can't find filter function in office 2019
Hi, I can't find filter function in office 2019, I made updates and read about the inside office but it's not available. Please advice? Regards Hisham
Andresen375
Copper Contributor
That's curious since I used it regularly for years until a few months ago and I've spent 4 months trying to figure out what was wrong so I could keep using it to quickly sort my customer list in Excel...
mtarler
May 27, 2022Silver Contributor
There is Filter functionality in older Excel but not the FILTER() cell function.
You (old Excel) can Create Tables or add the Quick Filter drop downs or just go under the Data tab and use the Filter button to filter a set of data.
You (old Excel) can NOT write a cell based formula to dynamically FILTER a set of data and return the results to this new location.
Does that help?
You (old Excel) can Create Tables or add the Quick Filter drop downs or just go under the Data tab and use the Filter button to filter a set of data.
You (old Excel) can NOT write a cell based formula to dynamically FILTER a set of data and return the results to this new location.
Does that help?