rolling

  1. R

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top