+ Reply to Thread
Results 1 to 3 of 3

Is there a way to automatically compute averages of groups of data in a single column?

  1. #1
    Registered User
    Join Date
    02-04-2015
    Location
    Portland, Oregon
    MS-Off Ver
    2007
    Posts
    2

    Is there a way to automatically compute averages of groups of data in a single column?

    I have about 90 data files exported from a laboratory apparatus. Each of these data files has a single column of data (usually about 1000 "rows") spread across three groups. These groups are separated from each other by blank cells and are of varying size. Is there any way to automatically compute averages of these three groups and put those average values into their own cells at the top of the spreadsheet? I don't need them to be named or anything, I can do that myself after the averages are computed since the groups are always in the same order. Basically I need a formula/function/macro that will select data ranges in a single column based on separation by blank rows and put their averages into easily-accessible cells. Thanks in advance.
    Attached Files Attached Files
    Last edited by Pokeclipse; 02-05-2015 at 02:16 PM. Reason: Added attachment

  2. #2
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Is there a way to automatically compute averages of groups of data in a single column?

    Could you provide a sample spreadsheet (with sensitive information cleaned out) that we can take a look at?

  3. #3
    Registered User
    Join Date
    02-04-2015
    Location
    Portland, Oregon
    MS-Off Ver
    2007
    Posts
    2

    Re: Is there a way to automatically compute averages of groups of data in a single column?

    Sure, I added an attachment to the first post.
    Last edited by Pokeclipse; 02-05-2015 at 02:17 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with grouping data and calculating averages from groups
    By SH1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2020, 03:57 PM
  2. Averages of different groups of data in a single sheet
    By jpdickson in forum Excel General
    Replies: 11
    Last Post: 07-15-2014, 09:39 AM
  3. Calculations on first lines for entire groups of data in a single column
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 11:43 AM
  4. How to display averages, min and max from varying data sets and sub groups
    By shoey_123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2013, 09:55 PM
  5. [SOLVED] Formula to Compute Averages - Ignore Zero (Blanks)
    By Neane in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2012, 07:08 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1