Find highest value and state its cell name

Solved/Closed
Fessi Posts 3 Registration date Wednesday January 29, 2014 Status Member Last seen January 30, 2014 - Jan 29, 2014 at 07:34 AM
Fessi Posts 3 Registration date Wednesday January 29, 2014 Status Member Last seen January 30, 2014 - Jan 30, 2014 at 03:34 PM
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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 29, 2014 at 11:11 AM
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.
0
Fessi Posts 3 Registration date Wednesday January 29, 2014 Status Member Last seen January 30, 2014
Jan 30, 2014 at 03:34 PM
Thank you so much for your help

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


Thank you

Be well

Stefania
0