.tg

  1. U

    Macro to create specific Date format

    I want to create a macro that will display the weekly date format as shown in my sample data. I need to carry this down across cell ranges in column A of my worksheet. Ex: A5:A30, A35:A86, and A93:A128. I may need to adjust the ranges but once I see the macro, I can adjust it accordingly...
  2. U

    Array or SumIF Formula

    I have my data as shown in rows G7 thru M31. I want to create a formula on each row in column M that takes the value in the quantity columns and the text values in the adjacent rows and gives a sum total. Ex: Yellow= 270, Blue = 2,430, Red =7500, Black 15360, and Green = 870 Here’s two...

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