tval

  1. J

    Add condition to unique list - VBA

    Hi all, I have the below macro which extracts a unique list. Is there any way to add a condition to this, so that the unique list only consists of names where Named_range_1 = Named range 2? Both of these named ranges aren't in the existing code below Thanks! Sub...
  2. J

    VBA: SUMIF then left with largest values

    Hi all, The below code populates a unique list, which is about 2000 rows of text. I need to then to SUMIF the results, using named ranges I have setup: Range="Security_description" Criteria = the text generated in the unique list above Sum range = "notional_value" Once the SUMIF is complete...

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