average incremental

  1. M

    help on getting formula for this

    Hi! I need help to simplify this process. Is there a shortcut formula to get the average of % difference from one row to the next row in column A without me computing the difference of per row and then taking the average after? e.g. A (Amount) B (difference from lower to higher) 8840...
  2. B

    Running Totals omitting blank cells

    Hello All, I am currently working on a marking spreadsheet for teachers where the teachers need to have running scores regardless of how many mark entries they have for their students. I am using the followin formula to get a total, but what I need is a running total so that the students get...
  3. C

    Incremental Average

    I have a data set from a DAQ device that I need to downsize I need to take the average of every 50 point increment, my data is in columns, as an example a1 a2 a3 a4 a5 ... a... I would need the average(a1, a3, a5 ...) in one cell, then average (a2, a4, a6...) in the next any ideas?

Watch MrExcel Video

This Week's Hot Topics

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
Top