Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Have a list of several hundred records.
Each record has a unique name in column A and a value in column B. Would like to know the top/bottom values associated with each record, WITHOUT SORTING THE COLUMN(S). Someone on TechRepublic posted this possible solution, which would sums the five largest values in Column B. Index(Large(B1:B100,{1,2,3,4,5}),1,1) Index(Large(Range,Rank(s)),Row,Column) Now I need to pull the values (names) in Column A that are on the same row as the five largest values in Column B. I don't understand the second line - Index(Large(Range,Rank(s)),Row,Column) - or if that is the right way to go about this. I'm looking for a column of cells with the top five values in one column and the name from column A next to it. Result would look like this: Rank Col. C Col. D 1 Smith 100,000 2 Johnson 99,000 3 Jones 85,000 4 Roberts 79,000 5 Davis 66,000 Maybe some unholy concatenation of Vlookup. I don't care how complicated it is. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hash function for large strings | Excel Worksheet Functions | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
how do I insert a function that chooses between two text values? | Excel Worksheet Functions |