+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 18 of 18

Missing values how to Average each midnight (after 23 values)

  1. #16
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,384

    Re: Missing values how to Average each midnight (after 23 values)

    Who're your asking? There is no *-1 in my sample file
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

  2. #17
    Registered User
    Join Date
    11-11-2018
    Location
    Australia
    MS-Off Ver
    MS Ofiice 2010
    Posts
    6

    Re: Missing values how to Average each midnight (after 23 values)

    I was asking samba_ravi this question. If you know you can reply too why -1 and 1 in formula below

    ''M2=AVERAGE(OFFSET(M2,HOUR($B2)*-1,,24,1))
    Try the above formula, copy and paste it where you want to get average
    generally we get circular reference in the above case because your excel options were changed to enable iterative calculations. ''

  3. #18
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    5,384

    Re: Missing values how to Average each midnight (after 23 values)

    I haven't seen where samba_ravi used it but all it does is set the offset to the column that the contents in B@ refer to to the previous column
    If Hour(b2) = let's say 7 then the results is 6

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1