Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Array formula needed
Assuming that Column A contains the team name, and Column B contains the
score, try the following... D1, copied down and over to Column E: =INDEX(A$1:A$10,MATCH(LARGE($B$1:$B$10-ROW($B$1:$B$10)/10^10,ROWS(D$1:D1) ),$B$1:$B$10-ROW($B$1:$B$10)/10^10,0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Adjust the ranges accordingly. Hope this helps! In article , "Ann" wrote: Hi, I have a list of team names and scores, how can I use an array formula to sort the scores descending by team name? I have heard this is doable but am struggling so far Any help much appreciated Thanks Ann |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
Trouble shooting#NA error in Array formula | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |