Results 1 to 2 of 2

Thread: Calculate Slope and average via VBA in Excel

  1. #1

    Angry Calculate Slope and average via VBA in Excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hey Guys,

    I am somehow stuck in my vba macro . I am using Excel 2010. I have an excel List with measures for different days/month in different years (see attachment).

    What I need is the following calculated in excel VBA in a cell the average and the slope for the year 2000, 2001, 2002, ...:

    Year Average Slope
    2000
    2001
    2002
    ...

    Since my original table is pretty long it would be nice to solve that problem via vba.

    Thanks a lot for any help.

    Cheers,

    Michael
    Attached Files Attached Files

  2. #2
    Seeker joseph4tw's Avatar
    Join Date
    May 2012
    Location
    South Florida, USA
    Posts
    13
    Articles
    0
    Hello,

    I don't think you need VBA for this solution. A couple of formulas should do the trick. I'm assuming the following:
    Y2 = Measurement 4
    Y1 = Measurement 2
    X2 = Measurement 3
    X1 = Measurement 1

    I added a column to calculate the slope for each date's measurements. Then I added a single formula that took the average of all of the dates.

    Now, if you want to filter for a particular date range, you should consider making a pivot table for this. Please take a look at the new sheet that I created. Please let me know if you need instructions on how I made the pivot table. It's very powerful and it would be my preferred solution to this problem.

    Measurement.xlsx

Posting Permissions

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