Top value
Disregard my post, I forgot to sum them.
I think Steve got your answer.
John
"John" wrote in message
...
Try this
=INDEX($A$1:$A$7,MATCH(LARGE($B$1:$B$7,1),$B$1:$B$ 7,0))&LARGE($B$1:$B$7,1)
This will give you the name and value in the same cell.
You can separate them if you want it in separate cell.
Adjust range to your needs.
HTH
John
"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!
|