Find highest value and state its cell name [Solved/Closed]

Report
Posts
3
Registration date
Wednesday January 29, 2014
Status
Member
Last seen
January 30, 2014
-
Posts
3
Registration date
Wednesday January 29, 2014
Status
Member
Last seen
January 30, 2014
-
Hello,

I have the following issue:


in A and B:
Marche 160,994
Puglia 463,251
Lombardia 405,626
Emilia- 542,009
Lombardia 451,468
Puglia 205,191
Trentino- 31,332
Sardegna 1,162,856
Molise 2,067,917
Campania 338,602
Sicilia 56,074
Piemonte 205,152
Lombardia 259,526

I need to sort top 5 on a different tab. There are other columns that do not allow me the ZtoA Filter. With the function Large I can already find the top 5 but I do not know how to state the appropriate cell name to it.

Can someone help me please?


2 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Fessi, Good afternoon.

I did an example for you.
http://speedy.sh/3s8uu/29-01-2014-en-kIOSKEA-Top-5-records.xls

Is this what you want?
Please, tell us if it worked for you.

Have a nice day.
Posts
3
Registration date
Wednesday January 29, 2014
Status
Member
Last seen
January 30, 2014

Thank you so much for your help

I had to adjust a bit the formula and voilà .... it worked.


Thank you

Be well

Stefania