Reading your question, it appears that you want to identify the product that has the largest spread in values, and the two values for that product that are the maximum and minimum.
Ideally the solution will tell me per Product which Values have the greatest difference and return the two Values
In the data you supplied, Product1 for instance has a spread of 13.50 (max 42.00, min 28.50)
The last two products in the table both have the largest spread of values (30.00)
If you want to identify the one or more products with the largest spread you could do the following:
A B C D E F G H
1 Value1 Value2 Value3 Max Min Diff. Max diff.
2 Product1 39.00 42.00 28.50 42.00 28.50 13.50
3 Product2 52.00 56.00 65.20 65.20 52.00 13.20
4 Product3 46.00 60.00 34.00 60.00 34.00 26.00
5 Product4 90.00 110.00 80.00 110.00 80.00 30.00 Product4
6 Product5 72.00 60.00 90.00 90.00 60.00 30.00 Product5
7 Max diff. 30.00
The two products with the maximum difference are identified by their names.
The formulas for row 2, cells E2 to G2 are:
Note the $ signs in H2
Drag these formulas down as far as row 6
The formula in G7 is
The 'result' i.e., the products with the largest spread could be identified by using conditional formatting and the row of data or just the cells with the product name would be highlighted in colour, or bold etc. rather than having the Max diff. column.