Highline Excel Class 19: Advanced Filter Extract Data 9 Examples

Learn about using Advanced Filter to extract data from an Excel List / Table / Database. See these 7 Advanced Filter examples:
1. Extract data with 1 criteria
2. See how Criteria and Extract areas get Named
3. Extract data with 2 or more AND criteria
4. Extract data with 2 or more OR criteria
5. Extract Unique Records
6. Extract data To Different Worksheet
7. Extract data To Different Workbook
8. Add column with True False Formula
9. Extract data with formula criteria
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Science & Technology

Tags:

• Excel
• Advanced
• Filter
• Extract
• Data
• AND
• OR
• criteria
• Formula
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[chiefs2k6]

i have a question that may be very simple but i cant figure it out, in my criteria i need codes that are Less Than or Equal to 7, so i put in <=7 in the chart but it doesnt work out right, then i tried <7 and it gives me only codes less than 7 not including 7....what is the notation for Less Than or Equal to?????

[ExcelIsFun]

@chiefs2k6 , Less Than or Equal to is:

<=7

You got it right. I am not sure what is causing your trouble.

[clemopcl]

terrible sound (or pronounciation? "if you want to download mmmpfffmpf, click on mffffffpmmmmmffff mmppp, then click on hmmmpffff hhmmmm mmmm"). I gave up after 1 min.

edit: the vid is nicely done, i intended to run it with sound off, but when using headphones (instead of hi-fi with a little bass), I got every word.

[ExcelIsFun]

@clemopcl , get workbooks at:

people.highline.edu/mgirvin/Ex­celIsFun.htm

[bodrulm1]

Excellent video. I didn't know how to use logical formulas with Advanced filter and now I do. Your videos are super

[ExcelIsFun]

@bodrulm1 , I am glad that the vid helps!

[Batooony]

I hate excel. And it'd be pretty lame if I fail college because of it.

[danianla90]

i don't hear

[ExcelIsFun]

I don't have a good answer for hat one. Try posting to the best Excel question site:

mrexcel[dot]com/forum