Top value
Hi, the problem is that i need this top values in another sheet. that's why i
need the formulas. and the sheet with the database is connected to a database
and i cannot modify it.
So i need a formula to make the sum by names and than to display in another
sheet, the top name and sum. In the cell bellow i need the second top value
and name....and so on....
Can this be done?
"Jacob Skaria" wrote:
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!
|