+ Reply to Thread
Results 1 to 3 of 3

Hi team, i have a raw data file to find the averages of the each Year in a row.

  1. 06-16-2020, 06:46 AM #1
    viswanathchenna04
    viswanathchenna04 is offline
    Registered User
    Join Date
    01-21-2020
    Location
    india
    MS-Off Ver
    2016
    Posts
    12

    Hi team, i have a raw data file to find the averages of the each Year in a row.

    Hi team, i have a raw data file to find the averages of the each Year in a row.

    I need help to develop VBA code for the above query.

    I have raw data from Jan 2019 to dec 2030 upto 8000 rows.

    Here i have to place the average values from last column +2 of the raw data for 2019, 2020,....till 2030.....

    header should display 2019,2020,....like that and below average values for those years based on the data....

    Thanks in Advance.
    Reply With QuoteRegister To Reply
  2. 06-16-2020, 08:45 AM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Hi team, i have a raw data file to find the averages of the each Year in a row.


    Hi,

    may not need any VBA procedure just using Excel easy formulas …
    Reply With QuoteRegister To Reply
  3. 06-16-2020, 09:26 AM #3
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Hi team, i have a raw data file to find the averages of the each Year in a row.

    ...or another option, and in the absence of a workbook to be sure, try using a Pivot Table.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Arrange data year-wise for individual team
    By dibyendu2280 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2019, 09:05 AM
  2. Office 365 Excel - Pivot - Comparing agent averages and team averages from Grand Total
    By gus.martin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-11-2019, 03:07 AM
  3. Need help to consolidate data for 20 users in a team to a single file
    By softpuneet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2019, 04:39 PM
  4. [SOLVED] countifs to find the total count between this year and last year for series of data
    By maher2014 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2016, 02:39 AM
  5. Finding Averages by Month from a multi year daily data range
    By Trevasaurus in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-07-2015, 07:18 PM
  6. i need a way to find out the averages of data from 4 samples in 20 treatments
    By Billnelson in forum Excel General
    Replies: 7
    Last Post: 08-05-2015, 06:38 PM
  7. [SOLVED] VBA Help needed to create separate sheets for each team by year
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-05-2014, 12:42 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