Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
show only items with values on chart | Charts and Charting in Excel | |||
show more items in validation list | Excel Worksheet Functions | |||
PivotTable - show top items | New Users to Excel | |||
filtering to show items in a listbox | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |