Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    174
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Need five days average of stable values for stable unstable data

    Hello All...
    I have column which contains stable unstable data. I need to get the last five days average of stable data when unstable values comes. I mean last five days average of stable days.

    Spreadsheet is attached
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Jan 2014
    Posts
    5
    Thanks
    0
    Thanked 1 Time in 1 Post
    Has anyone helped you with this yet? Or did you find a different solution?

  3. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    174
    Thanks
    56
    Thanked 0 Times in 0 Posts
    Dear Daianel,
    Many thanks for your reply ,no still I unable to get any solution or way to resolve this issue... I am doing manually after generating my report. Please help

    Best regards

  4. #4
    New Lounger
    Join Date
    Jan 2014
    Posts
    5
    Thanks
    0
    Thanked 1 Time in 1 Post
    You have the numbers in a spreadsheet. Are you familiar with Access? The way I solved it was through a little vba code that would run through the numbers I had in a table to determine how many times in a row there were valid numbers. When it finds the right number, (in your case 5 in a row of stable numbers) it writes those to a table so I can do what I need.

    Send me a direct message if you want to pursue this route.

    Diane
    Last edited by DianeHolliday; 2014-01-27 at 17:01.

Posting Permissions

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