I know this is probably very easy but for some reason my mind is not working today. I have a spreadsheet and I am trying to filter for MPI only not CLAMPING, DAMPING or any other word containing MPI.

http://www.excelfunctions.net/ExcelFilter.html

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thanks but that wasn't helpful

Meaning? Please post a sample sheet showing desired results

Autofilter with the " containing" filter should help

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

In column "I" I want to be able to filter by MPI bout exclude any instances where MPI is part of a word like CLAMPING or DAMPING

Here is the file and it is column "D" not "I"

Attached Files

Copy of MPI TTOs.xlsx (166.3 KB, 11 views)

Try advanced filters http://www.bettersolutions.com/excel...T419412321.htm

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post