In the dataset below, the first column is the class. The second column and the third column are the max and mins by the fourth column grade, respectively. The last two columns are how I would like to display the results. I am trying to find the Max by class that does not include the return result to be of grade B. The same for min: trying to find the min by class without the return result to be of grade B. How would you do this? Attached will be excel sheet with data.
1 2 5 A 5 5
1 4 7 B 5 5
1 5 8 C 5 5
2 8 11 A 8 7
2 6 9 B 8 7
2 4 7 C 8 7
3 3 6 A 4 6
3 9 12 B 4 6
3 4 7 C 4 6
4 8 11 A 8 11
4 9 13 B 8 11
4 9 12 C 8 11
5 7 10 A 7 5
5 7 10 B 7 5
5 2 5 C 7 5
6 4 7 A 4 7
6 2 5 B 4 7
6 4 7 C 4 7
7 -8 -5 A -8 -5
7 9 12 B -8 -5
7 -8 -5 C -8 -5
8 4 7 A 4 5
8 2 5 B 4 5
8 2 5 C 4 5
9 6 9 A 9 8
9 10 8 B 9 8
9 9 16 C 9 8
Bookmarks