Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A Function to Return Top 5 Values Only
I have a sheet with the following detail which I wish to Return the Top
5 Sales Locations only in Sheet2. My summary detail is as follows all located on Sheet 1 ColA = Location Name ColB = Sales Revenue ColC = Sales Ranking Number (1 = highest) On Sheet2 I wish to just see whatever locations are in the Top 5 with their respective Sales revenue Amounts, so eg London £10,750 Rank No 1 Paris £7,500 Rank No 2 etc until I show the Top 5 I have 35 locations in total on Sheet1 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions | |||
return multiple corresponding values in excel | Excel Worksheet Functions |