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
Bookmarks