I would be grateful if anyone could assist with the following excel problem
I have a spreadsheet (attached) which contains an extract of some sample data.
What I need to do is obtain minimum values
- Each test (MainTest in column A) produces multiple datasets which have values as (A1-A5 and B1-B5)
- Each MainTest can have a "Subtest" (e.g. set1, set2, set3 etc).
I require to get minimum values for each Maintest and any subtest out of the datasets.
please see "desired result" tab.
I have tried pivot tables without any success but require a solution that does not need VBA as I need to use in in many different excel files. The number of Maintests, subsets and datasets can vary.
is this possible
thanks in advance