Assign header to both columns and use Pivot Table. DataPivot table....Drag
and drop name to 'Row field' and the values to Data items area..
set AutoSort options from Right clickField SettingsAdvanced

--
Jacob (MVP - Excel)


"puiuluipui" wrote:

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!