=GRANDE(SE($A$1:$A$20=A1;B1:B20);1)
=GRANDE(SE($A$1:$A$20="MILANO";B1:B20);1)
=INDICE(A:A;CONFRONTA(GRANDE(SE($A$1:$A$20=A1;B1:B20);1);B:B;0))
=SUBTOTALE(4;B2:B20)