Forum Discussion
Solved
Trying to find the MIN and Max Values based upon multiple criteria
I am trying to find the min and max value of a column depending on the criteria of other columns.
Sample of data:
| 1/2 | 3rd | LPK02 | 876F | Banana | 124.0 | 122.2 |
| 1/2 | 3rd | LPK02 | 876F | Banana | 124.0 | 122.2 |
| 1/2 | 3rd | LPK02 | 876F | Banana | 124.3 | 123.1 |
| 1/2 | 3rd | LPK02 | 876F | Banana | 124.3 | 123.1 |
| 1/2 | 3rd | LPK02 | 876F | Banana | 124.3 | 123.1 |
| 1/2 | 3rd | LPK03 | 877F | Strawberry | 121.8 | 122.4 |
| 1/2 | 3rd | LPK03 | 877F | Strawberry | 121.8 | 122.4 |
| 1/2 | 3rd | LPK03 | 877F | Strawberry | 121.8 | 122.4 |
| 1/2 | 3rd | LPK03 | 877F | Strawberry | 120.2 | 119.6 |
I need to find the values of column 6 based upon columns 1, 2, and 3.
I have tried to figure out MIN, Max, Filter functions but the results keep being data from other parts of the spreadsheet.
With a pivot table.
column1 column2 column3 Min. of column6 Max. of column6 1/2 3rd LPK02 124 124,3 LPK03 120,2 121,8 - I have not used Pivot Tables much how do you get multiple columns for the same source data?
