Looking for Tickers with their Smallest values

[XcelLearner]

Hi,

I have a data array of n (n>100) stock tickers with their respective values. The tickers and their values are randomly distributed, not in an order. I need to look for tickers with largest values, which I used LARGE and ROWS together with XLOOKUP functions. However, when there are two tickers with indentical values, the formulae only display one ticker.
For example, in this table, I have two tickers (AFG, FJFGJ) with value of 64, but only one ticker (AFG) is shown. Please refer to the table.

How could I revise the formula so that both AFG and FJFGJ will be shown? I use Office 365.

Thank you very much.

 

[bebo021999]

smallest formula is largest formula, change "AGGREGATE(14" to 15

Book1
	A	B	C	D	E
12	Largest
13	F			A	77
14	K			B	88
15	C			C	90
16	E			D	78
17	B			E	90
18				F	96
19	Smallest			G	63
20	J			H	76
21	I			I	52
22	G			J	52
23	L			K	92
24	H			L	67
Sheet1

Cell Formulas
Range	Formula
A13:A17	A13	=INDEX(D:D,AGGREGATE(14,6,ROW($E$13:$E$24)/($E$13:$E$24-ROW($E$13:$E$24)*10^-2=AGGREGATE(14,6,$E$13:$E$24-ROW($E$13:$E$24)*10^-2,ROWS($1:1))),1))
A20:A24	A20	=INDEX(D:D,AGGREGATE(15,6,ROW($E$13:$E$24)/($E$13:$E$24-ROW($E$13:$E$24)*10^-2=AGGREGATE(15,6,$E$13:$E$24-ROW($E$13:$E$24)*10^-2,ROWS($1:1))),1))

 

[Fluff]

Another option

Fluff.xlsm
	A	B	C	D	E
12	Largest
13	F			A	77
14	K			B	88
15	C			C	90
16	E			D	78
17	B			E	90
18				F	96
19	Smallest			G	63
20	I			H	76
21	J			I	52
22	G			J	52
23	H			K	92
24	A			L	67
25
Data

Cell Formulas
Range	Formula
A13:A17	A13	=TAKE(SORT(D13:E23,2,-1),5,1)
A20:A24	A20	=TAKE(SORT(D13:E23,2,1),5,1)
Dynamic array formulas.

 

[XcelLearner]

Thank you very much Bebo021999 and Fluff. Much appreciated your help.

I tried the solution by Fluff and it works beautifully. One thing I love about it is it is so elegant and simple.

 

[Fluff]

Glad we could help & thanks for the feedback.