advanced data extraction

  1. C

    Advanced Formula Help - INDEX MATCH MATCH? VLOOKUP? Please help :(

    Hi guys, Wondering if anybody can help me - I have been trying to figure out this formula for 2 days now, with no luck :( I'm trying to figure out how to use Excel to find and return a value. It's quite difficult to explain (sorry, my brain is exhausted after trying to figure this out), so...
  2. D

    Turning Data extraction into an inserted module.

    I am using the following formula to extract data between carrots and it works flawlessly. =MID(B3,FIND("^",B3)+1,FIND("^",B3,FIND("^",B3)+1)-1-FIND("^",B3)) What I would like to do is to be able to bring up VBA and paste code to add this function to my selectable list (such as fuzzyvlookup)...

Watch MrExcel Video

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