Forum Discussion
riaanl007
Aug 04, 2021Copper Contributor
Help wiht excel auto filter
Hi, I have a problem in Excel that I need some assistance with please. I will try to explain to the best of my ability. I have a spreadsheet with multiple tabs. Let’s say Tab 1 is my “informatio...
mathetes
Aug 04, 2021Gold Contributor
See the attached. This uses the relatively new Dynamic Array function called FILTER. If you don't have a recent release of Excel it won't work.....Here's also a link to a good YouTube introductory video about this function. https://www.youtube.com/watch?v=9I9DtFOVPIg