Thread
:
Top value
View Single Post
#
1
Posted to microsoft.public.excel.misc
puiuluipui
external usenet poster
Posts: 468
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!
Reply With Quote
puiuluipui
View Public Profile
Find all posts by puiuluipui