partial text

  1. M

    If userform textbox contains a value then...

    Hi, I am trying to make a label visible/invisible depending on the partial value of a textbox in a userform. So the text box will contain lots of different text but if it contains Top of the card or bottom of the card etc then i want te label to be visible otherwise i want the label to be...
  2. A

    Excel - Sumif/Sumproduct Not Working; Criteria contains partial text

    I need your help in getting the right formula for this. In column B, I have a list of items called Support Type. There're just 2 types, 535 and 532. These are taken over from a larger table with a formula. Column D lists the Employee Names. Also taken over from another table with a formula...
  3. M

    Advanced Filter

    How would you set up advanced filter if you want to collect records of a dataset that contain numbers stored as text, and you want them starting with the partial text 646&"*" or 647&"*". I have a dataset where a column contains account code in text format such 6****** and I want all of those...
  4. B

    Advanced Filter NOT Criteria with Partial Text

    Hello, I am having trouble with this as I would like to use Advanced Filter using NOT criteria for partial text. I have customer names in Column A and Revenue in Column B. The customer names contain various store name and numbers so I would like to filter out customers that don't contain the...
  5. C

    find partial match of string between two arrays

    I have two arrays. Array A has a list of multiple terms in a column such as this: <tbody> Urinary Bladder Cancer|Bladder Tumors|Transitional Cell Carcinoma of the Bladder|Malignant Melanoma|Melanoma|Skin Cancer|Carcinoma, Non-Small-Cell Lung|Lung Cancer Platinum Sensitive Ovarian...
  6. I

    Search for partial text from cell value

    Ok... so I have a simple piece of code that works fine. Basically it is checking the ActiveCell to see if any part of the cell contains the word "Cat" and if it does, it returns "True" in the cell one column to the right. 'Checks the activecell value to see if any part of the cell contains the...
  7. L

    [Help Needed] Sum IF matching partial text via single cell using numeric values for match

    In excel work book one, I have account codes that look like this. <tbody> 00-1-110-31011 00-1-110-31031 00-1-110-31042 </tbody> This account code occupies one cell and is followed by a $ value in the next adjacent cell. In excel work book two, I have account codes that look like this...
  8. I

    VBA search partial text and copy to a variable number of columns

    OK... so here's what I need that I can't figure out. Below in Column A is a list of Students with their teacher's name. In column G is a list of Teacher's names for this worksheet. In H2, I have a counta formula which tells me the number of teachers for this grade. I need a macro that will...
  9. S

    IF Formula Using Wildcard to Find Part of Text

    I am trying to write a formula that will look at the contents of a cell (D19) and see if it contains the text "R-". If D19 contains "R-", then value of D21 for which I am writing the formula would be "240V 1-phase". If D19 doesn't contain "R-", then the value in D21 would be "460V 1-phase"...
  10. C

    Cell contains partial text from a list

    Hi, I have a list (1) of first in last names, and a list (2) of just first names. I want to be able to find whether a cell in list 1 contains one of the first names in list 2. Example List 1: John S (N/A) Matt K (yes) Eric F (yes) Mary Y (N/A) List 2: Zack Matt Amy Eric
  11. A

    Partial text match

    Hello, Would really appreciate your kind help here...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have 2 lists of customer names (from 2 different systems) as a result I have multiple names for the same customer. (even in the same list)<o:p></o:p> So...
  12. J

    Find Partial Text In Cell from Another Column

    Ok, so I am trying to search for a name from one cell in a column on another spreadsheet. They are not exact matches because one spreadsheet has the middle initial and the other doesn't. So trying to search a column another spreadsheet for partial text in one cell and return "yes" if it's...
  13. I

    Is there a macro/add-in to allow partial text filtering using one column to filter another?

    How do you write a macro, script or conditional formatting (or is there an add-in I can buy) that will use a partial text match from cells in one column (column J), to filter the list of phrases in another column (Column A). I found a formula that lets me filter column A by just one cell in...

Some videos you may like

This Week's Hot Topics

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
Top