contains a value

  1. F

    Vba help - IF cell has colour & contains text then ...

    Hi All, I am struggling with a code line for a simple macro. Thank you in advance for taking some of your time and to anyone who will help me :) I have 2 sheets ("data" and "macro"). Sheet "data" contains details of users (column A contains data of user 1, column B of user 2 etc) these data...
  2. K

    VBA to Remove all rows in Table that contains a speified text string

    I have search the forum but found no thread that was able to solve my issue: I have a spreadsheet named "Files" in which I have a table named "data" where header begins in row 2. My header in column A2 is "filenumber" and in that column I need to delete entire row where the text "voc" appears...
  3. H

    Vlookup value if contained in arey

    hi there, i have a sistematic problem with data and i have to be creative with exported data for them to be usable. i deal with products that have certain ID problem is One product can have MORE diffreretnt ID's. I coded an export to combine all ID' that refer to same product in one CELL (ref...
  4. T

    Sum specific amount if cell contains certain value

    Hello to all, First post in the forum and I need HELP! Is there a formula that can sum a specific amount if a cell contains a certain value? Example: Apple =SUMIF(A1,”Apple”,500) would return 500 Apple, Banana, Oranges =SUMIF(A3,”Apple”,500)&SUMIF(A3,”Banana”,500)&SUMIF(A3,”Oranges”,500)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top