#1
|
|||
|
|||
How to find exact matches only in an excel spreadsheet
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. |
#2
|
||||
|
||||
__________________
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 |
#3
|
|||
|
|||
thanks but that wasn't helpful
|
#4
|
||||
|
||||
Meaning? Please post a sample sheet showing desired results
Autofilter with the " containing" filter should help
__________________
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 |
#5
|
|||
|
|||
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
|
#6
|
|||
|
|||
Here is the file and it is column "D" not "I"
|
#7
|
||||
|
||||
Try advanced filters http://www.bettersolutions.com/excel...T419412321.htm
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need to improve speed of Excel macro that searches for whole word matches | Marrick13 | Excel Programming | 20 | 02-19-2016 09:54 AM |
Find and replace in word document repeated for every item in excel spreadsheet | Daniell | Word | 1 | 02-17-2015 04:38 AM |
How to find spreadsheet connected to merge template | infomaven11 | Mail Merge | 1 | 09-18-2014 03:02 PM |
How to find exact phrase | CabbageTree | Outlook | 2 | 05-14-2012 11:24 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |