2/1/2019

  1. J

    Countifs/sumproduct help!!!

    Please see below: Column J and I are the ones where I need help with: * Does the customer have one contract with one service type for the entire year? If so, return SYSR (Single Year Single Rev) * Does the customer have one contract with multiple services for the entire year? If so, return SYMR...
    • jeongs1
    • Thread
    • 2/1/2019 contract countifs multi conditional sumproduct
    • Replies: 1
    • Forum: Excel Questions
  2. I

    IF .. then DATE comparison

    I'm looking to use a macro and not a formula to do delete old invoices automatically. please help if today is greater than 2/1/2019 then delete column A
  3. C

    Segregating dates via month

    I have used a filter in my VBA code to sort a date column Oldest to newest. List of dates: 9/12/2018 9/15/2018 10/15/2018 11/26/2018 12/1/2018 12/30/2018 1/5/2019 1/30/2019 2/1/2019 3/1/2019 etc I would like code to keep everything prior to current date in same grouping as current month then...

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