accumulate

  1. T

    Power Query: Group by - Output Multiple Sum Columns

    Hello all, I'm currently working on a query that will eventually feed into a chart. The original table was too large and exceeded the chart's maximum 255 data series so I wanted to rewrite the query to group the rows by multiple columns with constant names. The issue is that the header names of...
  2. I

    Rests in vba, and accumulation.

    Hi, how are you helping me with the following? What I need is that in a cell eg B7. This cell is automatically updated for me. And I need that when the next value is lower than the previous one accumulate in the cela for example C7. If the value of cell B4 is greater than the previous one, they...
  3. L

    find trend in times found in one cell

    Hello, I am not sure if this can be solved in excel or not. I have 41,000 rows of something like: <tbody> <tbody> <tbody> 13:23:15,13:23:15,13:23:15,13:24:15, 13:24:24, 14:32:00, 14:34:23, 14:35:00, 14:38:15 </tbody> </tbody> </tbody> I want excel to accumulate count as follows...
  4. D

    Accumualted Totals when input on different sheet changes

    I am tracking hours and calculating paid leave based on the total hours worked from the beginning of the year. Looking for an automated way to calculate accumulated totals from a continuously changing input from a different sheet (or same sheet). I have a "Clear All" button to clear all input...
  5. M

    Sports Betting Excel Spreadsheet

    Hello All, I have recently aquired Excel 2010 and still getting used to. As the new football season is about to start I am looking to make a Spreadsheet with my football accumilator selections on. I am hoping to have a column with the odds of each bet, and at the bottom a formula which will...
  6. B

    Accumulate Sum that meets a condition

    Hi guys, I've been struggling with a macro, I'm really new at this. I'm trying to do a cumulative sum from some values at Excel spreadsheet until that variable meets a given condition. Then, when that condition is met, I want a cell of Excel to take a value of another cumulative sum. Sub...

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