Results 1 to 17 of 17

How do i average two coloumns for 6 months rolling

Threaded View

  1. 10-07-2008, 08:18 AM #1
    Murphy1985
    Murphy1985 is offline
    Registered User
    Join Date
    10-07-2008
    Location
    UK
    Posts
    9

    How do i average two coloumns for 6 months rolling

    Hi,
    I need some help with regards a spread sheet,i need to know how to calculate a six month rolling average for hours in AD column and AE column, this average would be entered in to AF1.
    the date column is AC the date is not consecutive it does miss days out.

    Hope someone can help and if i need to give anymore information just ask.

    Chris[/CENTER]
    Last edited by Murphy1985; 10-07-2008 at 08:38 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 12 Month rolling average.
    By Glen Blaha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2008, 09:20 AM
  2. Excel charting - Use Trendline (6 mos Rolling Average)
    By rockycj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-22-2008, 03:10 PM
  3. 12 months rolling data in graph format
    By brissy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-20-2007, 08:05 AM
  4. average rolling periods
    By RobPatrick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2007, 05:26 AM
  5. Rolling 12 month average
    By tclaud in forum Excel General
    Replies: 1
    Last Post: 10-16-2006, 03:53 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1