Excel Forum

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.