Hi,

In "C1" enter the formula

=IF(COUNTIF($A$1:A1,A1)=1,SUMIF(A:A,A1,$B$1:B1),"" )

And fill/copy down as far as your list goes

In "D1" enter the formula

=INDIRECT("a"&MATCH(LARGE(C:C,ROW()),C:C,0))

And fill/copy down to "D5"

Regards
Steve

"puiuluipui" wrote in message
...
Hi, i have a table like this:

john 4500
john 1200
mary 900
jim 5000
john 3700
mary 2300
jim 1400

And i need formulas to extract top 5 values:
I need something like this:
John 9400
jim 6400
....etc

Can this be done?
Thanks!