containing text

So I don't think there is a single formula to sum certain columns that contain specific text if that text is in a cell with other text, for example <tbody> A B $657.34 XX Oil company 234 $34.20 Gas $432.98 Car payment $653.97 Oil supplier $400.00 Oil $56.50 Gas $678.76 XX Oil...

I want excel to look at a cell and if it contains the word "special" then I want it do run my code. I am not sure how to do this. Here is what I have so far. Sub special() Count = Range("a65536").End(xlUp).Row For i = 2 To Count If cells(i,4).value = [contains the word "special"] then...

Hi guys! Here's my problem: I have some huge txt files (~700k lines) with csv data from stock prices. One of the columns is the name of the company. So I want to get only the lines of certain companies. I actually already have a solution, but it is taking too much time. I think it may take...

I have table 1: <tbody> Column 1 James Phillips Formula column formula to return from column 2 below (Phillips) Lando Boris formula to return from column 2 below (Lando) For Mr. B. McComb formula to return from column 2 below (McComb) </tbody> and table 2: <tbody> Search in this column...

=(SUMIFS(Avastin100!AA:AA,Avastin100!I:I,"1st Inspection",Avastin100!$D:$D,">="&EDATE("October 1, 2011",0),Avastin100!$D:$D,"<="&EDATE("December 1, 2011",1)))/E25 I want to add a check to see if the cell in column AW contains the text "*CMO*" Not sure if there is a "contains" function that will...

Hello, I am working on this spreadsheet for a while and can't get it working...any help is appreciated On the first worksheet "transactions" a row contains a financial transaction. With another macro new transactions are imported when available in another file. For a new transaction on a row...

I am trying to figure out how to delete a whole row if the row contains the text "Run Date". However, the cell with that text will also have varying text before and after run date. I tried using the below, but it won't work since my cell doesn't contain exact text.