# rolling

1. ### Rolling Calendar Attendance and Tardy Tracker

I'm trying to help my manager create a spreadsheet to track various types of absences and leave. I've linked the spreadsheet here to see what I have set up, but need to figure out how to extract the right data. I am looking for a way to figure out absences based on a rolling calendar year, and...
2. ### Rolling Filter for Table

I have a table that is filtered by monday dates to pick up the current monday date and the previous 10 mondays to create a rolling summary. I am wondering is there any way I can setup a dynamic filter so it always picks up the previous 10 weeks each monday rather than manually removing one date...
3. ### Find the highest rolling average from a range

Hi All, I have numerical data in over 1000 cells in ColumnA, and I am in need of finding the highest average from a rolling average of 10 consecutive cells. Can anyone help? Thanks in advance Pedro
4. ### Sumifs rolling total - calculation not adding up

Hi, I am trying to do a running total based on Date and Hours. The end result that I want (table A) is the "rolling hours" column. Table A DATE Person Hours Rolling Hours Tue, 05/28/19 Peter Pan 12.06 12.06 Wed, 05/29/19 Peter Pan 4.97 17.03 Sat, 06/01/19 Peter Pan 12.10...
5. ### Adding number of times code appears in cells over a rolling period

I have a formula, found elsewhere, that counts the totals of cells from current date – backwards for one year =SUMIFS(\$L\$5:\$BDQ\$5,\$L\$3:\$BDQ\$3,"<="&F37,\$L\$3:\$BDQ\$3,">="&DATE(YEAR(F37)-1,MONTH(F37),DAY(F37))) Data in \$L\$5:\$BDQ\$5 Dates in ,\$L\$3:\$BDQ\$3 Todays date in \$F\$37 This works perfect for...
6. ### Tough One!

I have a data set that I am trying to calculate a moving average. In the below Data set is the date started, date ended, and value is the simply the number of days between those dates. The moving average I am trying get is a rolling 12 month average shown on a monthly basis. See column of 12...
7. ### Calculate Rolling Average

I have a data set that I am trying to calculate a moving average. In the attached picture the Data set is the date started, date ended, and column C is the simply the number of days between those dates. The moving average I am trying get is a rolling 12 month average of Column C shown on a...
8. ### Can I auto convert an entry of digits to time format?

Here's a weird one. Due to the sheer laziness of some team members, they want to enter "1730" into a cell and have it convert to "17:30" Likewise, "530" would convert to "05:30" (5:30AM) I'm literally rolling my eyes because they can't be bothered to just physically write "05:30" (and yes...
9. ### Rolling return for 1Y/2Y/3Y/5

I have a price point available with me from 1979 to 2018. I am looking to calculate the rolling return of this years for 1/2/3/5 Years period. Also, This returns I am looking in Percentage terms. Please advice right method
10. ### formula question

this may be more of a math question but in column A i have a rolling 12 month balance column B is a basis points assigned to a product Column C is the "new value" example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the...
11. ### Rolling Average of last ten of a certain criteria

Hi. I'm after some help with adding a formula to calculate a rolling average of the last 10 entries of a certain criteria. In column A I have five different locations. There are multiple entries for each location in the date order of measurements taken and column L has a measurement taken at...
12. ### Sorting by values in pivot table

Hi all, I have looked online but can't seem to find an answer to this. I have currently filtered the date by specific year which looks like below. What I am trying to do is use a slicer so that I can choose between dates and also get a text return linked in but I cannot seem to figure out how...
13. ### Count-if + rolling weeks

Problem Statement: Column B through D track a rolling count of items that are open and closed for a duration of the last 30 days based on today's date. (Blue table) I'm trying to accomplish the same function by using rolling weeks instead. (Yellow Table) This is simple, but I've been at this...
14. ### Creating a rolling sum function

Hi everyone,I am trying to create a spread sheet that adds up my staff's hours worked for a rolling 119 day period, sounds easy but I have to ignore any day that they have taken as leave but still include a 119 day period. For example if I had a member of staff who took 6 days off in that 119...
15. ### Auto-populate ongoing rolling rota by date

Hi All, My husband has an 8 week rolling rota and I'd like to create a spreadsheet where he can enter in the year and it will automatically fill the dates he's working and off. There are actually 8 teams, each with a different 8 week rolling rota so it would be good for a drop down to show the...
16. ### Rolling Hour Sum in DAX

Hello Friends, I need some help finding a DAX solution to a solved Excel problem in the link below. https://1drv.ms/x/s!AuhgWIfRbRU2oXSl2z7NPx8Q9YjR Essentially I need a rolling sum that calculates a row count for all rows that exist within 1 hour of the original time. (Ideally, being able to...
17. ### VBA Timer with rolling list

What I was asked to do is to create a countdown timer that starts with the first value in a predetermined list of roundtrip times, and when it reaches zero, it has to move on to the next value and so on, till the list has been completed and then stop. This list with time values will eventually...
18. ### VBA Timer with rolling list

What I was asked to do is to create a countdown timer that starts with the first value in a predetermined list of roundtrip times, and when it reaches zero, it has to move on to the next value and so on, till the list has been completed and then stop. This list with time values will eventually...
19. ### GetPivotData for the past 5 weeks

I am currently using a pivot table which shows information regarding how much time an employee has worked, which is separated by week number. I would ideally like a GETPIVOTDATA formula to take this information and place it onto a dashboard screen, however only show the data from the past 5...
20. ### Calculate Rolling Average - Skipping Columns

I am trying to calculate a rolling 12 month average. The hard part is I need to keep a column ("Total" column). I am not sure the easiest way around this. I'm assuming OFFSET can be used, but am looking for ideas. TIA <tbody> May 2017 Jun Jul Aug Sep Oct Nov Dec Total Jan 2018 Feb Mar Apr 1...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### 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.

### Which adblocker are you using?

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

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