learned

  1. B

    countif question

    Good Morning, and thanks for the help. I am working with a string of 169 grades (numbers), >90, <70, 80-89, 70-79 I am good with countif on the >, < but need help with those two ranges. Is countif the best formula to use, and if so how to i use it for the ranges, and if not what would you...
  2. My Aswer Is This

    Congratulations Mr. Excel Thankful for 20 Years of MrExcel on November 21

    Glad I have learned a lot here and have been able to help others.
  3. M

    Learning VBA like I Learned to Use Matlab

    I learned Matlab before I used Excel VBA. What I learned to rely heavily on when coming up with Matlab scripts is the "Workspace" window, which displayed the declared variables and their current value in memory. This would allow me to investigate the value of variables as the program progresses...
  4. JenniferMurphy

    Why are font color values negative?

    While working on a macro to do some highlighting, I had the need to change both the fill color and the font color. Using the macro recorder, I learned that I can set the fill color to red (255,0,0) using this code: With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic...

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