How to use the FILTER Function in Excel (multiple use cases)

[@claudiafreeman9929]

I find this function to be more cumbersome, having to type out the formula and have a value identified to specifically search for, than the dropdown feature. I use the dropdown so I can filter on multiple columns and for several purposes when working with large amounts of data. If I needed it for the example used, then I can see it being very useful. I also have the filter on Quick Access Toolbar so it’s easy to find and I love the “Contains” text filter when searching for items that may not import from a system as accommodating as others. But I love all your videos! Keep them coming 🙂

[@rickguerrero2282]

Really nice video!

[@m.w.6099]

This option for sure, I hate the sort & filter dropdown. These dynamics are great!

[@andyhydes1982]

It's a great feature, but then you have to manually type in the Representative or month to filter the data. With the current filter function you don't need to do that.

[@raooftarahandesign]

Very nice 👍 😊

[@andreausa123]

Great ❤ if there is one column which includes numbers, is it possible to get the sum of all rows numbers ?

[@thegooplife]

I can't seem to use this in a table column.

[@АнастасияТригубенко-б3н]

How to use this function if I will add new data in the main table below?

[@udayallada]

Provide the range upfront

[@mohammedalhamad5039]

😉😉😉😉😉😉😉😉😉😉😉😉😉😉😉 اوووووووة انتي رائعه جداااااااا

[@Mouna-v2b]

goood