acb

  1. J

    Search Range of Cells and Sum Values

    Hi, I was wondering if there is an easy way to search a group of values and sum the corresponding number listed in the ROW below it. <tbody> COM BVILLE CUR CAP WV2P PAM 40 16 16 8 32 64 MPB ACB TZ I-84 Traf BAL 40 8 0 24 16 16 MFE DM MKT 219 I79 Ohl PAM 32 0 24 64 8 6 PAM COM...
  2. H

    Insert hyperlink to send email to VLOOKUP recipient

    I am looking to be able to insert a hyperlink to a column of words to email a set recipient based on a VLOOKUP i.e. Column A: ABC ACB BAC BCA BAC ACB ABC BCA EmailAddressSheet: ABC | ABC@outlook.com ACB | ACB@outlook.com BAC | BAC@outlook.com BCA | BCA@outlook.com Does anyone know if any...
  3. R

    Extracting text between 2 special characters

    Hi, I have a column of text fields and I'd like to extract the text in each cell based on 2 conditions. I need to extract the text that comes after the very first dahs (-) AND before the colon (:). For example I have the following string: MT202I-ACB: /BNF/ And I only want to extract "ACB"...

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