Excel Dynamic FILTER Function to Return Multiple Values

You can use Excel's new FILTER function to return a part of data.
What if you'd like to filter multiple criteria and return ALL match results? You can use the new Excel Dynamic Array FILTER Formula! It's like the dynamic or automatic version of Excel's advanced Filter feature. You can return Filtered results based on AND as well as OR conditions.

Software Tools/Products by Teknisha:

Recommended Gadgets/Products:

Must Watch Playlists..

Excel Tutorials:

Excel Chart Tutorials:

Excel Pivot Table Tutorials:

Excel Gsuite Tutorials:

Excel Tips & Tricks:

Powerpoint Tutorials:

Gadget Reviews:

Thanks for watching!!! 😊🙏

Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.

Follow me on below to stay connected👇

[bertvantol]

GREAT !!! Thanks.
I have another question, hope you can answer it ...
I have a Year calendar.
When I select a Date, that Date must be automatically copied to another cell.
How to do this ??

[mllawhorn]

Thanks for sharing!
Does this still work if your table has formula references in it?
I have a table I to use this with that is medium sized; 25 columns across. The last 10 columns are formula references or look-ups of various sort. I can select any of the first 15 columns to "include" in the filter function, but not the last 10.
Even after taking a "paste values" version of the table in consideration, the filter function still returns #N/A on any of these last 10 columns.