Thread: Top value
View Single Post
  #1  
Old June 3rd, 2010, 01:34 PM posted to microsoft.public.excel.misc
puiuluipui
external usenet poster
 
Posts: 467
Default Top value

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!