Thread: [Solved] Excel inverse search or find
View Single Post
 
Old 05-03-2021, 08:47 AM
oscarlimerick oscarlimerick is offline Windows 8 Office 2013
Advanced Beginner
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default 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
Attached Files
File Type: xlsx excel sample.xlsx (8.2 KB, 8 views)
Reply With Quote