Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Filter Data to Display the Results that Begin With Specified Text or Words in Excel - AutoFilter
Macro: This Excel macro automatically filters a set of data based on the words or text that are c...
Excel VBA Course
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




Excel Magic Trick 524: Extract Records Partial Text Not Criteria: 4 Methods


See how to extract records with Partial Text NOT CRITERIA 4 different ways:
1.Filter and Does Not Contain Easiest Method (00:55 minute mark)
2.Advanced Filter (02:51 minute mark)
3.Advanced Filter and Recorded Macro (8:48 minute mark)
4.Array Formula using COUNTIF, SEARCH, ISERROR, INDEX, IF, ROWS, ROW, and SMALL function (16:26 minute mark)





Got a Question? Ask it Here in the Forum.