noncontiguous range

  1. J

    Input box with non contiguous range in VBA not working

    I have a macro that creates an Outlook email with a table containing data from selected ranges in Excel. However, it does not work for non-contiguous ranges. When user manually types comma or holds CTRL to select multiple ranges, it only grabs the first set of continuous range. How can I make it...
  2. J

    CountIf on non contiguous named range

    Below is a set of data I am working on. I have named the customer satisfaction range as "CustomerSatisfaction" then i have applied a filter on the cities ie filter by "Melbourne" then i have named the customer satisfaction column with the filter on and called it...
  3. Dr. Demento

    Fill in missing values

    When I receive data, all ID need to be unique strings, even if they're blank or all 'x' as a place holder. For these, I assign a pseudo ID (starting at one). I've even come up with a way to ensure that as long as I run the sub in a single session, the pseudoID don't get reused (I used a Public...
  4. E

    SUMIF on noncontiguous ranges

    Please see sample data. My goal is for N5 and down to sum any cost value with the corresponding code (1,2,3...). I read a bit and tried to create named ranges for the Range and Sum Range; CODE and COST respectively. They are the same size and shape, and thought they should work. However, I'm...

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