reds

  1. C

    Count If with Breaks

    I am trying to come up with a formula for Column S (count of Broad Names with 1 or more 1's in the unique name count, split by field ID" which will tell me how many Broad Names are being used per Field ID. I added in the correct answer already just manually but I need to figure out a formula to...
  2. V

    An intelligent way to change colours in conditional formatting (excel 2013)

    Hi Everyone I am faced with a task of replacing colours with different shades. The demanding part lies in the conditional formatting, which turns out to be highly convoluted, most probably as a result of much reorganising to the rows and columns done after the conditions were set up. To...

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