Excel Advanced Filter - part (1 of 2)

Part 2: • Excel Advanced Filter ...
This tutorial video is part 1 of a two part lesson on using Advanced Filters in excel.
Advanced filtering is extremely useful when you need to find pertinent information in piles of data.
Be sure to watch my other Excel tutorial videos on my channel, including more advanced techniques
and many useful and practical ones. Be sure to Subscribe and Comment.

[@MrCarlos5372]

You made it simple. Easy to understand. Thank you

[@chrisserpa7337]

Great job - just enough without being too much.
Looking forward to seeing if multiple filters could be created at the same time, and then change dynamically as the data set changes.

[@pynkstarr]

Really glad I found this video and you. Not sure why I didn't do this before my exam last week. I'm taking MOUS and have been having issues with excel esp scenarios, solver and now I can cross advanced filter of my list. Thanks for the video.

[@rdjalayer]

thanks for watching, glad I could help

[@MustafaAhmed-mb7hu]

How can i filter based on max value

[@jijugeorge3077]

am glad i finally found this video........because after a long search i got a good video which really helped me in knowing what advanced filter is

[@jijugeorge3077]

really excellent

[@mollypauze9260]

This is super helpful. Thanks so much. This is just what I was looking for--step by step, clear.

[@johnmaciog3776]

Like your style, easy to understand. I need to develop a spreadsheet to track construction projects, project costs and prioritize for multiple medical facilities. Being able to filter and sort data for presentations to staff and contractors. This will get me started.

[@kr9409]

very nice. appreciated comment that each row is a separate filter. learned something!

[@hasnadiana]

Great! Good example, clear explanation and nice presentation.
Thank you very much :)
-diana, Jakarta

[@sabrinakay5631]

outstanding. looking forward to try this again.

[@sweetpea7715]

thankyou easy to understand

[@hamidshaikh8568]

Great..... Thank You for your Knowledge

[@wasimdingankar3599]

thank u sir 4 ,making to learn something new which i never heard of

[@johnq3543]

Thank you for doing these video's

[@Existentialist946]

Rather than put >150 or whatever. Could you not have that value 150 in another cell and reference the cell instead of putting in the number?

[@juded14]

Hi:
I have duplicates but want to choose the duplicate with the highest score. For example, Jaylen is listed 4 times.
Jaylen 68
Jaylen 57
Jaylen 95
Jaylen 85
How do I advanced filter excel to choose only 1 score for each person?

[@maggiepuddles2593]

thanks so much

[@harshilshah2568]

Thanks!

[@zzzzzzz1zzzzzzzzzz1z]

thank you

[@Ankush_1088]

thanku

[@azeemansar2862]

thank u sir very helpfull: I undestd vry wel

[@AsadUllahButt911]

All of this can be achieved much easily using pivot tables. 1.Why not pivot tables? 2.How can we use Advanced filters for other advanced purposes?

[@Existentialist946]

+Asad Ullah Butt I've never used pivot tables and have no idea what they are used for. I do a lot of filtering though. Is it worth learning about pivot tables?

[@ennykraft]

Advanced filters are much less useful than they used to be. In its simplest form, all of the things he showed us could be achieved with regular filters. They become really interesting when you use either use more criteria (last part of the video) or a formula (for example an IF function with "true" and "false" results) as a filter criterium. I also like to use it for getting a list of unique data in a column (although pivot tables could do that too).

[@patricknoonan3610]

Is there a formula I missed?

[@rimpakoley773]

THNK U

[@prachisrivastava4278]

thnku.. :)

[@patricknoonan3610]

Followed your steps several times but, all that happened was the data set copied and pasted.

[@rdjalayer]

check my channel I have a few on macros

[@tophana]

too many "OKs" ):-[

[@hemasondhiya9267]

macro