Career Evolve: Microsoft Excel tip that saved my life - filter a column by more than two values

Career Evolve is your partner in online learning and career development. Search our catalog of 28,000+ courses from over 21,000 top colleges and universities. Our partners have helped over 2 million students and continue to enroll over 30,000 students each month. Career Evolve provides you with access to free and affordable online training.

You can take courses in subjects varying from Philosophy to Computer Science or even Advanced Fiction Writing to Becoming a Physical Therapy Aide. Learn at your pace anytime and anywhere.
Career Evolve also integrates with LinkedIn to profile your achievements to potential employers.

Whether you are searching for micro learning from providers, such as Coursera, EdX or courses from leading Universities like MIT, Stanford and Peking University, Career Evolve is the answer for affordable learning and shrinking training budgets.

Invest in yourself with Career Evolve.

Discover your next learning opportunity from just one of our many Universities

Thursday, 20 October 2016

Microsoft Excel tip that saved my life - filter a column by more than two values

Do you ever find that you get lost in MS Excel as the deadline to deliver keeps tick, tick, ticking along? Here is the most recent MS Excel tip that saved my life.

Excel: filter a column by more than two values

http://superuser.com/questions/623380/excel-filter-a-column-by-more-than-two-values

Filter -> Custom Filter only allows me to filter by 2 IDs total.
Excel's Advanced Filter can filter for as many values as you want
enter image description here

Set up your criteria range. The header must be named exactly like the column where Excel should apply your filter to (data table in example)
Select your whole table (A1:A11 in example)
Go to: Menu Bar » Data » Filter » Advanced
Select your whole criteria range including the header under Criteria range (C1:C4 in example)

No comments:

Featured

	Starting a Consulting Practice Find out how you can earn income by sharing your training or knowledge with others.
	PMP ® Certification Prep 1 Begin a well-paying career as a project manager by preparing to take--and pass--the PMP® certification exam.
	How to Get Started in Game Development Take steps toward a new career in game development by building a foundation to design games in a wide variety of genres for different audiences and platforms.
	Accounting Fundamentals Gain a marketable new skill by learning the basics of double-entry bookkeeping, financial reporting, and more.
	Conversational Japanese Whether you want to learn conversational Japanese for travel or just for fun, you'll find this course makes it easy and enjoyable for beginners to master the essentials of the Japanese language.
	Introduction to QuickBooks 2015 Learn how to quickly and efficiently gain control over the financial aspects of your business using this powerful software program.