this-

  1. K

    Extracting multiple keywords from a cell

    I am trying to create a formula that will extract the campaign name that generated the lead in the sheet. The campaign name column looks like this- 2016_00_InboundWeb_Request_A_Demo 2016_04_PPC_Google_Generic 2016_00_InboundWeb_InboundCall&Chat 2016_12_Telemarketing_Infocore_Spa-Salon The...
  2. RichardMGreen

    Application.WorksheetFunction issue

    Hi all I've got a worksheet function using SUMPRODUCT that will count all the Mondays in any given month. It works if I put it on a worksheet quite nicely. The formula is this:- =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH("05/01/2018",-1)+1&":"&EOMONTH("05/01/2018",0))))=2)) You can swap the...
  3. V

    Some symbol in formula wanted to understand..

    Dear All Board Members, I need here help to understand in this formula... What is the meaning of this-

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