a2=8

  1. S

    VBA for cell division

    I’m trying to come up with a macro that will divide the values in a cell range (of an active cell row), by the value of the active cell. In other words: A1 = 4 (active cell), A2=8 and A3=16. The result would be A2=2 and A3=4. I would select the first cell in any given row, and then run the...
  2. B

    Idiot Question About Averaging

    Ive got two columns, A has amounts and B has set percentages literally "40%", "35%", etc. which all are set exactly 5% apart. I need to see what is the average of all percentages as determined by the amounts in column A, meaning whatever actual is most popular, resulting in a number like say...

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