isnumbersearch

Hello all, I am trying to create a report that shows all cleaning failures over the course of a month. Failures are called both "Failed" and "Aborted". The formula I have been using works well for Failed. However, I need to be able to search for both of those terms. Everything I have found says...

Hello, I am new to Excel and my brain is fried from trying to search the forum for similar questions/answers. I am trying to populate a column with data based on information from 2 other columns. In the attached worksheet, I want to populate column E with the names of the clients based on...

I am coding qualitative data from call center agent notes, and I'm trying to adapt another researcher's Excel method. I've adapted it a bit for my own purposes, and I just can't seem to get this last piece. I'm using Excel for Mac version 16.81 So, I have all my agent notes in Column A. In...

Hi, I'd like to be able to count the number of certain words in a cell, e.g. in E4 I have Lamb, rice, coffee, coffee. In L4 (Beverages column) I want to know how many drinks have been had of either: beverage, tea, coffee ovaltine In L4 I'm using: =IF(COUNTBLANK([@[Food taken]])>0,""...

Hey guys, I need help with my formula: =FILTER(TDB,(ISNUMBER(SEARCH(F8,TDB[Fund Manager])))+(ISNUMBER(SEARCH(F8,TDB[Description])))+(ISNUMBER(SEARCH(F8,TDB[Tags]))) *(ISNUMBER(SEARCH(F19,TDB[Verticals]))),"Not Found") When I added the part in bold, the formula ignores it. What I try to...

Hi all, I'm trying to use the if statement to check for blank cells and then do something if the cell is blank, and if not then leave the cell as is. Below is the formula I'm currently using...

Hello! I am trying to get the following to work, but I think I am missing a ( somewhere along the lines: New Formula =IF(ISNUMBER(SEARCH("Attn Needed",E2)),"Collection...

Hi There! I am using Excel 2016 version and wanted to add another ISNUMBER(SEARCH) function but my Excel version will not accept more than 6 nested ISNUMBER(SEARCH) functions. Is there another way of doing that? Thank you Here is what I have. I just need to ad another search for R20...

Hi Guys, Is there a way where two cells can be matched on containing some of the same text? I have been using ISNUMBER(SEARCH()) to match but this only matches the whole string. See the below example: <tbody> AMCO Amco Services TRUE </tbody> using the ISNUMBER(SEARCH()) function will match...

Hello, I am trying to create an aging table for receivables. I have a report that gives me all the detail of what is outstanding but I want to convert the data into 5 buckets. The report gives me the name of the individual, amount, and what term it was from. <tbody> Name Balance Term...

Hi I've got a formula which searches for specific text in a cell, then returns a phrase if that text is in the cell. In the example below, if the word "Now" appears in the text in cell A1, then the phrase "Fixed Price Discount" will appear in cell B1. The formula I have used is...

Hi, I am hoping that there is a way to link a vlookup formula with a isnumber(search formula. I have a working ISNUMBER(SEARCH formula, but what I would like to do is to add in a VLOOKUP so that I am searching within the right cell for the text string. To furhter complicate what I am trying to...