find and return

  1. L

    VBA to find referenced cell contents and return adjacent cell

    Greetings and salutations Mr.Excel folks. First off, thank you all for being here and willing to help. I've used this forum for a great many other deeds in the past. I am not a VBA wizard, but I know my way around excel a fair bit. Today I got a fun one that I feel jumps into the land of VBA...
  2. N

    RegEx-pert needed to help with string matching!

    Hi all, I am trying to search two columns of strings to pick out a reference number. The standard for the reference number has been abused over the years so I'm hoping that someone here could help me with a suitable regex to pick out any one of the possibilities so that I can return the...
  3. K

    Sumproduct mid find

    Hi, I am trying to make a simple formula to calculate values in an array of cells. The cells contain text and numbers, text or can be blank. I am not an excel professional... Data sample: Cell Cell-content B2 Mr. Hansen Dlx Dbl /55 B3 Mr. Olsen Sup Sgl /45 B4 Mrs. Simpson Std Sgl /40 B5 Robert...

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