Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have data in the range A1:B5 as follows:
a 5 b 3 c 6 d 5 e 7 In the range E1:E5, I have added the following multi-cell array formula that returns the largest values in B1:B5 sorted highest to lowest: {=(LARGE($B$1:$B$5,{1;2;3;4;5})} I want to add a similar formula in D1:D5 that returns the corresponding "a, b, c, d, and e" values that go with the largest to smallest number sort. In other words, when complete the range D1:E5 should look like this: e 7 c 6 a 5 d 5 b 3 I've tried multiple combinations of INDEX, MATCH, AND OFFSET but I keep getting the letter "a" returned twice for the number 5 and/or error messages. Thanks for your help. John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array formula that alphabetizes a list | Excel Worksheet Functions | |||
Propagate Array Formula Down Column | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
formula (IF) question | Excel Worksheet Functions | |||
Formula to sum and list highest to lowest | Excel Worksheet Functions |