Spreadsheet: 736241d1623429664-highlight-max-value-for-each-combination-of-values-in-other-columns-excel-highlight-max
Sheet: Sheet1

Sort1 | Sort2 | Mobility | Resilience |  |  | Every Combination |  |  | Example >> |  | Sort1 | Sort2 | Mobility | Resilience
1.Hunter | 1.Helmet | 1 | 1 |  |  | 1.Hunter | 1.Helmet |  |  |  | 1.Hunter | 1.Helmet | 1 | 1
1.Hunter | 1.Helmet | 2 | 2 |  |  | 1.Hunter | 2.Gauntlets |  |  |  | 1.Hunter | 1.Helmet | 2 | 2
1.Hunter | 1.Helmet | 1 | 3 |  |  | 1.Hunter | 3.Chest |  |  |  | 1.Hunter | 1.Helmet | 1 | 3
1.Hunter | 2.Gauntlets | 1 | 1 |  |  | 1.Hunter | 4.Leg |  |  |  | 1.Hunter | 2.Gauntlets | 1 | 1
1.Hunter | 2.Gauntlets | 2 | 3 |  |  | 2.Warlock | 1.Helmet |  |  |  | 1.Hunter | 2.Gauntlets | 2 | 3
1.Hunter | 3.Chest | 1 | 1 |  |  | 2.Warlock | 2.Gauntlets |  |  |  | 1.Hunter | 3.Chest | 1 | 1
1.Hunter | 3.Chest | 1 | 1 |  |  | 2.Warlock | 3.Chest |  |  |  | 1.Hunter | 3.Chest | 1 | 1
1.Hunter | 3.Chest | 2 | 1 |  |  | 2.Warlock | 4.Leg |  |  |  | 1.Hunter | 3.Chest | 2 | 2
1.Hunter | 3.Chest | 1 | 1 |  |  | 3.Titan | 1.Helmet |  |  |  | 1.Hunter | 3.Chest | 1 | 1
1.Hunter | 3.Chest | 1 | 3 |  |  | 3.Titan | 2.Gauntlets |  |  |  | 1.Hunter | 3.Chest | 1 | 3
1.Hunter | 4.Leg | 2 | 1 |  |  | 3.Titan | 3.Chest |  |  |  | 1.Hunter | 4.Leg | 2 | 1
1.Hunter | 4.Leg | 1 | 2 |  |  | 3.Titan | 4.Leg |  |  |  | 1.Hunter | 4.Leg | 1 | 2
1.Hunter | 5.Class | 1 | 1 |  |  |  |  |  |  |  | 1.Hunter | 5.Class | 1 | 1
1.Hunter | 5.Class | 3 | 1 |  |  |  |  |  |  |  | 1.Hunter | 5.Class | 3 | 1
1.Hunter | 5.Class | 1 | 5 |  | Highlight [NAME] value in column C and D, |  |  |  |  |  | 1.Hunter | 5.Class | 1 | 5
2.Warlock | 1.Helmet | 1 | 7 |  | for each combination of values in column A and B |  |  |  |  |  | 2.Warlock | 1.Helmet | 1 | 7
2.Warlock | 1.Helmet | 2 | 1 |  |  |  |  |  |  |  | 2.Warlock | 1.Helmet | 2 | 1
2.Warlock | 2.Gauntlets | 1 | 1 |  |  |  |  |  |  |  | 2.Warlock | 2.Gauntlets | 1 | 1
2.Warlock | 2.Gauntlets | 2 | 2 |  |  |  |  |  |  |  | 2.Warlock | 2.Gauntlets | 2 | 2
2.Warlock | 2.Gauntlets | 1 | 1 |  |  |  |  |  |  |  | 2.Warlock | 2.Gauntlets | 1 | 1
2.Warlock | 3.Chest | 5 | 1 |  |  |  |  |  |  |  | 2.Warlock | 3.Chest | 5 | 1
2.Warlock | 3.Chest | 1 | 1 |  |  |  |  |  |  |  | 2.Warlock | 3.Chest | 1 | 1
2.Warlock | 3.Chest | 2 | 4 |  |  |  |  |  |  |  | 2.Warlock | 3.Chest | 2 | 4
2.Warlock | 3.Chest | 1 | 1 |  |  |  |  |  |  |  | 2.Warlock | 3.Chest | 1 | 1
2.Warlock | 4.Leg | 2 | 1 |  |  |  |  |  |  |  | 2.Warlock | 4.Leg | 2 | 1
2.Warlock | 4.Leg | 1 | 21 |  |  |  |  |  |  |  | 2.Warlock | 4.Leg | 1 | 21
2.Warlock | 5.Class | 2 | 1 |  |  |  |  |  |  |  | 2.Warlock | 5.Class | 2 | 1
2.Warlock | 5.Class | 1 | 8 |  |  |  |  |  |  |  | 2.Warlock | 5.Class | 1 | 8
2.Warlock | 5.Class | 1 | 1 |  |  |  |  |  |  |  | 2.Warlock | 5.Class | 1 | 1
2.Warlock | 5.Class | 1 | 1 |  |  |  |  |  |  |  | 2.Warlock | 5.Class | 1 | 1
3.Titan | 1.Helmet | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 1.Helmet | 1 | 1
3.Titan | 1.Helmet | 1 | 2 |  |  |  |  |  |  |  | 3.Titan | 1.Helmet | 1 | 2
3.Titan | 1.Helmet | 2 | 1 |  |  |  |  |  |  |  | 3.Titan | 1.Helmet | 2 | 1
3.Titan | 1.Helmet | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 1.Helmet | 1 | 1
3.Titan | 2.Gauntlets | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 2.Gauntlets | 1 | 1
3.Titan | 2.Gauntlets | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 2.Gauntlets | 1 | 1
3.Titan | 2.Gauntlets | 2 | 2 |  |  |  |  |  |  |  | 3.Titan | 2.Gauntlets | 2 | 2
3.Titan | 2.Gauntlets | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 2.Gauntlets | 1 | 1
3.Titan | 3.Chest | 1 | 9 |  |  |  |  |  |  |  | 3.Titan | 3.Chest | 1 | 9
3.Titan | 3.Chest | 2 | 1 |  |  |  |  |  |  |  | 3.Titan | 3.Chest | 2 | 1
3.Titan | 4.Leg | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 4.Leg | 1 | 1
3.Titan | 4.Leg | 1 | 2 |  |  |  |  |  |  |  | 3.Titan | 4.Leg | 1 | 2
3.Titan | 4.Leg | 2 | 1 |  |  |  |  |  |  |  | 3.Titan | 4.Leg | 2 | 1
3.Titan | 4.Leg | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 4.Leg | 1 | 1
3.Titan | 4.Leg | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 4.Leg | 1 | 1
3.Titan | 5.Class | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 5.Class | 1 | 1
3.Titan | 5.Class | 2 | 2 |  |  |  |  |  |  |  | 3.Titan | 5.Class | 2 | 2
3.Titan | 5.Class | 1 | 1 |  |  |  |  |  |  |  | 3.Titan | 5.Class | 1 | 1