Thread
:
Top value
View Single Post
#
1
June 3rd, 2010, 01:34 PM posted to microsoft.public.excel.misc
puiuluipui
external usenet poster
Posts: 467
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!
puiuluipui
View Public Profile
View message headers
Find all posts by puiuluipui
Find all threads started by puiuluipui