Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 2016
SRT Tracker.xlsm | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
2 | Assembly | (All) | |||||||||||||
3 | Component | (All) | |||||||||||||
4 | Position | (All) | |||||||||||||
5 | Work | (All) | |||||||||||||
6 | Under/Over | (Multiple Items) | |||||||||||||
7 | Terminal | (All) | |||||||||||||
8 | |||||||||||||||
9 | Max of Under/Over | Column Labels | |||||||||||||
10 | Row Labels | Abramowicz, Chester | Alexander, Charles | Barney, Jim | Beard, Michael | Bridges, Michael | Buzzell, Tommy | Darnell, Jeff | Gividen, William | Godby, Steven | Gonzalez, Jose | Gordon, Gary | Hall, Joe | ||
11 | 1.2 | ||||||||||||||
12 | ACCESS | 0.5 | |||||||||||||
13 | AERODY | 0.4 | |||||||||||||
14 | APU-EL | 4.1 | 0.4 | ||||||||||||
15 | BODY | 5.5 | 0.3 | 0.6 | 0.3 | 0.5 | |||||||||
16 | BRKTRA | 0.6 | 1.4 | 1.4 | 0.2 | 4.6 | 0.5 | ||||||||
17 | BRKTRL | 1.6 | 0.9 | 0.7 | 0.6 | 1 | |||||||||
18 | CAB | 1 | 0.3 | 0.6 | 3.2 | 1.8 | |||||||||
19 | CHGSYS | 1.1 | 3.4 | 1.1 | |||||||||||
20 | COOLSY | 1.2 | 0.2 | 1.2 | 0.8 | ||||||||||
21 | CRNKSY | 1.9 | 0.8 | 0.8 | 2.3 | 4 | 3.4 | 1.1 | |||||||
22 | DRVLNE | 0.9 | |||||||||||||
23 | ELACCS | 2.1 | 0.3 | 0.6 | |||||||||||
24 | ENGINE | 1.6 | 0.8 | 0.2 | 0.6 | ||||||||||
25 | EXHSYS | 0.4 | |||||||||||||
26 | FRAME | 0.8 | 0.9 | 0.4 | 2.2 | 1.4 | 0.6 | ||||||||
27 | FUELSY | 1.2 | |||||||||||||
28 | GAUGE | ||||||||||||||
29 | HEATER | 3.5 | 3.5 | ||||||||||||
30 | HVAC | 2.7 | 0.6 | ||||||||||||
31 | INFLSY | 1 | 0.4 | 0.6 | |||||||||||
32 | INTAKE | 0.7 | |||||||||||||
33 | LGTSYS | 0.2 | 0.7 | ||||||||||||
34 | PWRUNT | 1.1 | 8 | 8.4 | 11.5 | 1.9 | 3.5 | 1.2 | 10.1 | 8.4 | 0.8 | ||||
35 | Q COMM | 0.6 | 0.6 | 2 | |||||||||||
Over .2+ |
I used =Max to pull up largest number in this data range which equaled (11.5)
I also used =large and pulled up the second largest number, etc...
I need to place anywhere in the sheet both the largest, second largest, third largest numbers AND also what those numbers match to in column A
So the largest = PWRUNT
Second largest is also PWRUNT
But let's say it was (3.4) which then should pull "CHGSYS"
I know I can't use VLOOKUP....and I've tried INDEX/MATCH but I'm not skilled in that and it isn't working...
Is this possible?