Pivot Table Challenge - Arrays?

[actjfc]

Excel friends,

The Pivot Below has more than 10,000 Codes. I need to find a formula or a way to get a list that looks like the summary on top.

The Description is the one corresponding to the maximum on the Total Column. I understand it can be done with Arrays. It will be a very elegant solution. I am curious if it can be solved by adding auxiliary columns to the Pivot Table Source. I appreciate any help! Thanks!

Excel 2019 (Windows) 64 bit
	B	C	D
4	Code	Description	Sum(Total)
5	1234	Description 1	440,813
6	23457	Description a	97,756
7
8	Total Expenses
9	Code	Description	Total
10	1234	Description 1	417,306
11		Description 2	7,931
12		Description 3	4,336
13		Description 4	4,229
14		Description 5	1,120
15		Description 6	927
16		Description 7	860
17		Description 8	839
18		Description 9	796
19		Description 10	599
20		Description 11	395
21		Description 12	358
22		Description 13	278
23		Description 14	245
24		Description 15	192
25		Description 16	158
26		Description 17	73
27		Description 18	69
28		Description 19	67
29		Description 20	39
30		Description 21	0
31		Description 22	0
32		Description 23	0
33		Description 24	0
34	1234 Total		440,813
35	23457	Description a	31,350
36		Description b	17,529
37		Description c	14,065
38		Description d	8,112
39		Description e	5,824
40		Description f	5,473
41		Description g	3,764
42		Description h	3,428
43		Description i	2,162
44		Description j	2,117
45		Description k	1,972
46		Description l	1,962
47	23457 Total		97,756
Sheet1

 

[actjfc]

Friends,

I was able to get a solution to my problem, and I want to share it with you, I repeated all rows in the Pivot, and used a combination of Index, Maxifs, and match, look at the formulas below, no need of arrays:

Excel 2016 (Windows) 64 bit
	B	C	D
4	Code	Description	Total
5	1234	Description 1	440,813
6	23457	Description a	97,756
Sheet1

Cell Formulas
Range	Formula
C5	=INDEX($C$10:$C$47,MATCH(MAXIFS($D$10:$D$47,$B$10:$B$47,B5),$D$10:$D$47,0),1)
C6	=INDEX($C$10:$C$47,MATCH(MAXIFS($D$10:$D$47,$B$10:$B$47,B6),$D$10:$D$47,0),1)
D5	=INDEX($D$10:$D$47,MATCH(MAXIFS($D$10:$D$47,$B$10:$B$47,B5&" Total"),$D$10:$D$47,0),1)
D6	=INDEX($D$10:$D$47,MATCH(MAXIFS($D$10:$D$47,$B$10:$B$47,B6&" Total"),$D$10:$D$47,0),1)

If you find a different solution, please post it!

Thanks!