Recent content by wolf767

It may be easier to understand if I mention I am referring to the results of a Lab, Codes 1&2 refer to serial numbers that define the sample tested sometimes the sample is of the same kind hence they "Should" somewhat match with others of the same serial numbers. A pivot table does not really do...

Hello you wonderful people, I am a bit stuck on an excel formula if someone could help me out it would be much appreciated. I need a way to calculate the min and max for each product, as I do with the average formula (=AVERAGEIFS(E:E,B:B,B3,C:C,C3,D:D,D3) (=AVERAGEIFS("Value...