Create Account

Similar Content

How to Quickly Find Data Anywhere in Excel
Tutorial: Finding specific records and/or cells is easy when using the Find tool in Excel. It is lo...

Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...

Vlookup Partial Match in Excel
Tutorial: Return Vlookup results on partial matches of a cell's contents. You could type the start,...

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorials

Featured Tutorial

Dynamically Update Drop-Dowm Menus in Excel

Featured Macro

Delete Empty Rows in Excel

Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions

See how to find a perfect match of 6 successive items using the AND and IF functions in two formulas:
1) Non-array formula
2) Array formula (much shorter and better formula, but requires Ctrl + Shift + Enter).

Got a Question? Ask it Here in the Forum.