I'm new to excel forum, however I have a query that I need solved as soon as possible. I'm not sure if a VBA or macros would be more suitable, however I'm looking for an answer by just using formulas.
Within my data, I have specific 'geology codes', and within each geology code, I have specific 'soil types', and within each soil type, I have varying 'densities / consistencies', and within each of these, I have a lab test result. I need a formula to present the minimum, maximum and average lab result for each density / consistency, of each soil type, within each geology code...
is there a way this can be done?
Example: Geology Code = Alc, for Alc I have 5 different soil types, for each soil type, I have 2 to 4 different densities / consistencies, and for each of these, I have a set of lab data... I need the min, max and average for each...
Any help would be greatly appreciated.