Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2016, 07:07 AM
zhead zhead is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Advanced Beginner
How to find exact matches only in an excel spreadsheet
 
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-08-2016, 07:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

http://www.excelfunctions.net/ExcelFilter.html
__________________
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
Reply With Quote
  #3  
Old 09-08-2016, 07:35 AM
zhead zhead is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Advanced Beginner
How to find exact matches only in an excel spreadsheet
 
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default

thanks but that wasn't helpful
Reply With Quote
  #4  
Old 09-08-2016, 07:51 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #5  
Old 09-08-2016, 10:36 AM
zhead zhead is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Advanced Beginner
How to find exact matches only in an excel spreadsheet
 
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 09-08-2016, 10:44 AM
zhead zhead is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Advanced Beginner
How to find exact matches only in an excel spreadsheet
 
Join Date: Mar 2015
Location: Texas
Posts: 32
zhead is on a distinguished road
Default

Here is the file and it is column "D" not "I"
Attached Files
File Type: xlsx Copy of MPI TTOs.xlsx (166.3 KB, 9 views)
Reply With Quote
  #7  
Old 09-09-2016, 07:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to find exact matches only in an excel spreadsheet Windows 7 64bit How to find exact matches only in an excel spreadsheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find exact matches only in an excel spreadsheet 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 exact matches only in an excel spreadsheet How to find spreadsheet connected to merge template infomaven11 Mail Merge 1 09-18-2014 03:02 PM
How to find exact matches only in an excel spreadsheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft