Results 1 to 6 of 6

How to display averages, min and max from varying data sets and sub groups

Threaded View

  1. #4
    Registered User
    Join Date
    06-13-2013
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: How to display averages, min and max from varying data sets and sub groups

    Thanks Sixthsense and FDibbons,

    I have attached an example.... You can see that I have two different 'geology codes' (Alc and Ca), and you can see for each 'geology' code that I have two different 'soil types' (CLAY and SAND), for each soil type, there are varying 'consistencies / densities' (i.e. Loose, Medium Dense, Soft, Firm, just to name a few), and the last column shows 'N' (which is essentially the lab result), which are just varying numbers.

    So, my expected output would to have a minimum, maximum and average 'N' result for each 'consistency / density' type, for each 'soil type' within each 'geology code'... i.e. I want the output over 6 columns, saying 'Alc', 'CLAY', 'Soft', 'N minimum', 'N maximum', 'N average'.

    I think it would be like a heap of IF loops etc embedded into one another (well, I actually have no idea) - or I'm guessing, I would have to write a code or something like that...

    Any help would be greatly appreciated.

    Many Thanks

    Shoey_123
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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