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 ...
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?
Detlef_Lewin Thank you I knew it had to be an easy solution. I learned something new.