partial string match

  1. B

    Array Formula with partial match.

    I am looking to do an array formula with a partial string match. Does not seem to be working. Are array formulas different than regular index-match formulas with partial string matches? This works great...
  2. hkydad

    Insert Data based on Partial contents of adjacent cell

    Hi, I apologize if this question has been answered but I wasn't able to locate the thread. What I am trying to do is insert a formula that looks at the adjacent cell to see if the text includes "-Ann" or "-SANN" and then enter ABCD or EFGH in the adjacent cell. So if column B includes...
  3. N

    Index & Match with Partial string possible?

    I have an excel spreadsheet that looks like the below. I need the formula on TAB 1 Column S to calculate if the Class in TAB 1 Column M matches the Master list in TAB 2 Column C, and if that matches, then it looks to see if TAB 1 Column N matches the first 3 characters and if it does return a...
  4. C

    Allow data to be easily filtered from multiple headings in a single column

    Hi all, I am open to any suggestions here.. I have an lot of data that is from a config file that I paste into excel. The data looks like this: <tbody> [heading 1] text 1 text 2 text 3 [heading 2] text 4 [heading 3] text 5 text 6 </tbody> I need to be able to filter...
  5. HackSlash

    Help cleaning up formula that concatinates two cell values based on a partial string match

    I'm not very confident with formulas. I made something really ugly and then thought "There must be a better way". I will first tell you what I want: I need to search for a partial string match on a cell in a known range on a different sheet. Once the match is found I need to take the cell...
  6. Z

    Match and group strings in a list box

    I have some previously made code that I need to use and Im a little rusty on my Visual basic for applications. There is a list in a form that is generated from a spreadsheet. The items in the list are generated in the following format, "lawyer's name - charges he defends": example: Johnson -...

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