Excel Advanced Filter - part (1 of 2)

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.

[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.

[MrCarlos]

You made it simple. Easy to understand. Thank you

[johnmaciog]

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.

[chrisserpa]

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.

[mollypauze]

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

[jijugeorge]

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

[kr]

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

[sabrinakay]

outstanding. looking forward to try this again.

[wasimdingankar]

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

[hasnadiana]

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

[rdjalayer]

thanks for watching, glad I could help

[johnq]

Thank you for doing these video's

[azeemansar]

thank u sir very helpfull: I undestd vry wel

[Existentialist]

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?

[juded]

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?

[AsadUllahButt]

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?

[patricknoonan]

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