Quote Originally Posted by versuswhat View Post
Thanks GerryZucca. That worked to retrieve the biggest value & name. Any ideas on how to get the top 5?
Also agree it makes more sense with the number
Those are allready the top 5
for the top 5 amounts with the second formula =INDEX($A$2:$A$132,MATCH(G2,$E$2:$E$132,0)) you'll have the list of top 5
€ 287.450.128,33 ROG.VX
€ 244.504.501,00 CRDI.MI
€ 191.236.008,73 ING.AS
€ 171.020.966,82 ENI.MI
€ 160.899.849,26 TOTF.PA