harris

  1. D

    Countif with multiple criteria and duplicates counted once

    Hi, how to write the formula for Countif with multiple criteria and duplicates counted once. I want the number of client seen by E name as a criteria funded by. if E name seen the client multiple times a day then it should consider as a one client count. I attached the sample table and answer...
  2. B

    formula question

    hello in column A i have a name that appears as Lawrence_Harris in Column B i would like it to appear as Harris, Lawrence any thoughts on how i could do this ty
  3. S

    how to preserve fill color when hiding/unhiding column with vba

    When "No" appears in a cell of a dynamic range I set the fill color to red in vba. A macro gives the option of hiding/unhiding the column containing this range. On unhiding the column, red is gone. How do I preserve the fill color without having to go through the range cell-by-cell on...

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