Reference item with highest value

[ParkourAngel]

index(a:a, match(large(b:b, 2), b:b,0))

This is the exact formula I need, but I can't figure out what a:a and b:b would be? I want to show the item with the highest total, would also like to show (in the same cell) what that total is. In a separate cell I'd like to show what the item with the 2nd highest total, and so on. Also, how can I make this dynamic to where it works the same no matter the changes in size of the pivot table? The name of the pivot table is "shortage" Thanks!!

 

[ExceLoki]

try this:
-------------------

Book1
	A	B	C	D	E	F
1	rt	item 1	item 2	item 3
2	3
3	6					item 1 -2000
4	8					item 2 -1500
5	11			1000		item 3 -1000
6	15
7	21		1500
8	34
9	35	2000
10	36
11	total	2000	1500	1000
Sheet2

Cell Formulas
Range	Formula
F3	F3	=CONCAT(INDEX($1:$1, MATCH(LARGE($11:$11,1), $11:$11,0))," -",LARGE($11:$11,1))
F4	F4	=CONCAT(INDEX($1:$1, MATCH(LARGE($11:$11,2), $11:$11,0))," -",LARGE($11:$11,2))
F5	F5	=CONCAT(INDEX($1:$1, MATCH(LARGE($11:$11,3), $11:$11,0))," -",LARGE($11:$11,3))
B11:D11	B11	=SUM(B2:B10)

 

[ParkourAngel]

try this:
-------------------

Book1
	A	B	C	D	E	F
1	rt	item 1	item 2	item 3
2	3
3	6					item 1 -2000
4	8					item 2 -1500
5	11			1000		item 3 -1000
6	15
7	21		1500
8	34
9	35	2000
10	36
11	total	2000	1500	1000
Sheet2

Cell Formulas
Range	Formula
F3	F3	=CONCAT(INDEX($1:$1, MATCH(LARGE($11:$11,1), $11:$11,0))," -",LARGE($11:$11,1))
F4	F4	=CONCAT(INDEX($1:$1, MATCH(LARGE($11:$11,2), $11:$11,0))," -",LARGE($11:$11,2))
F5	F5	=CONCAT(INDEX($1:$1, MATCH(LARGE($11:$11,3), $11:$11,0))," -",LARGE($11:$11,3))
B11:D11	B11	=SUM(B2:B10)

This works great thank you so much!! How can I match the highest numerical value for item 1 if the rows are dynamic? The amount of rows (Rt) change (max up to 33) according to how many different items it has. I tried just extending the match all the way down to after the 33rd Rt since I know I wont have more than that at any given time. This works great but this means I can't use all that empty space below this data. Also, I am using a pivot table so it refreshes and moves.

 

[ExceLoki]

here, try this. you may need to adjust the columns used and the search terms, but this gave me the same conclusion. i added an extra row and column to the pivot to show concept
-----------------------

multiple posts solutions-v3.xlsm
	A	B	C	D	E	F
1	Sum of value
2		item 1	item 2	item 3	item 4
3	3
4	6					item 1 -2000
5	8					item 2 -1500
6	11			1000		item 3 -1000
7	15				500
8	21		1500
9	34
10	35	2000
11	36
12	18
13	Total	2000	1500	1000	500
item w high value pivot

Cell Formulas
Range	Formula
F4	F4	=CONCAT( INDEX( INDIRECT(MATCH("Item*",B:B,0)&":"&MATCH("Item*",B:B,0)), MATCH( LARGE(INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),1), INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),0)), " -", LARGE(INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),1))
F5	F5	=CONCAT(INDEX(INDIRECT(MATCH("Item*",B:B,0)&":"&MATCH("Item*",B:B,0)), MATCH(LARGE(INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),2), INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),0))," -",LARGE(INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),2))
F6	F6	=CONCAT(INDEX(INDIRECT(MATCH("Item*",B:B,0)&":"&MATCH("Item*",B:B,0)), MATCH(LARGE(INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),3), INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),0))," -",LARGE(INDIRECT(MATCH("Total",A:A)&":"&MATCH("Total",A:A)),3))