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

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top