Investigate the functions LARGE, and LOOKUP.


"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!