Pulling info from Column A

[Noxqss38242]

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?

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Assembly	(All)		Value	Col A
2	Component	(All)	Largest	11.5	PWRUNT
3	Position	(All)	2nd largest	10.1	CHGSYS
4	Work	(All)	3rd largest	10.1	PWRUNT
5	Under/Over	(Multiple Items)
6	Terminal	(All)
7
8	Max of Under/Over	Column Labels
9	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
10								1.2
11	ACCESS		0.5
12	AERODY			0.4
13	APU-EL									4.1		0.4
14	BODY	5.5				0.3	0.6		0.3		0.5
15	BRKTRA		0.6	1.4	1.4			0.2		4.6			0.5
16	BRKTRL	1.6				0.9	0.7		0.6		1
17	CAB			1	0.3			0.6		3.2			1.8
18	CHGSYS		10.1	1.1				3.4		1.1
19	COOLSY		1.2	0.2						1.2			0.8
20	CRNKSY		1.9	0.8	0.8			2.3		4		3.4	1.1
21	DRVLNE									0.9
22	ELACCS			2.1				0.3		0.6
23	ENGINE		1.6	0.8						0.2			0.6
24	EXHSYS		0.4
25	FRAME		0.8	0.9		0.4				2.2	1.4		0.6
26	FUELSY				1.2
27	GAUGE
28	HEATER	3.5		3.5
29	HVAC			2.7				0.6
30	INFLSY	1							0.4		0.6
31	INTAKE		0.7
32	LGTSYS			0.2	0.7
33	PWRUNT	1.1	8	8.4	11.5	1.9	3.5	1.2	10.1	8.4		0.8
34	Q COMM				0.6							0.6	2
Sheet3

Cell Formulas
Range	Formula
D2:D4	D2	=LARGE($B$10:$M$34,ROWS(D$2:D2))
E2:E4	E2	=INDEX($A$11:$A$34,AGGREGATE(15,6,(ROW($A$11:$A$34)-ROW($A$11)+1)/($B$11:$M$34=D2),COUNTIFS(D$2:D2,D2)))

 

[Noxqss38242]

Works beautifully!

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.