View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
petenice81 petenice81 is offline
external usenet poster
 
Posts: 1
Default Show the top three items in a list

I'm trying to find a way to display the top 3 items in a random list of more
than 7 components. Assuming I have the following data:

Column A (value) Column B (components)
2.3 z
3.5 y
1.2 x
6.2 w
4.5 v

I want to return the following:

Top 3 highest by component

6.2 w
4.5 v
3.5 y


Is there an easy way to do this? I'm thinking I need to use VLOOKUP and
possibly the RANK function, but can't seem to get the logic figured out.
Thanks.