|
|
#1
05-03-2021, 08:47 AM
|
|||
|
|||
Excel inverse search or find
Good day excel forum experts. Is there a way, using excel, to find a cell that does NOT contain something. In the attached spreadsheet, all the cells in Column B, except for cell B8, contain the title name of the song ending with .mp3. This is just a small section of a huge list. If I do a search on "*.mp3", excel will identify all cells that have the .mp3 in them (which would be cells B4-B7 and B10).
But what I want to do is have it search for items in column B that DON'T contain the *.mp3, in other words I want it to flag cell B8 for my example. Is there any way to do this? Many thanks 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Inverse Grayscale in Slideshow mode | esersen | PowerPoint | 1 | 06-29-2014 11:19 PM |
 Find what box in Find and replace limits the length of a search term
|
Hoxton118 | Word VBA | 7 | 06-10-2014 05:05 AM |
|
How to obtain the inverse tan of a value in degree/minute second?
|
Jamal NUMAN | Excel | 3 | 07-27-2013 10:18 AM |
| Won't find in search | ep2002 | Word | 3 | 10-31-2012 05:24 PM |
|
How to get the inverse of the values in the same table?
|
Jamal NUMAN | Excel | 4 | 04-16-2011 06:24 AM |
Windows 8 
Office 2013
Threaded Mode