Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highest then alphabetical order By Names?
Hey All trying to get this formula working correctly:
{=INDEX('W1'!B:B,MATCH(LARGE('W1'!$AN$10:$AN$49+RO W($AN$10:$AN$49)/100000,ROWS($1:1)),'W1'!$AN$10:$AN$49+ROW($AN$10:$ AN$49)/100000,0)+ROW($AN$10)-1)} There are three names have the some totals right now how would I get this to list name in alphabetical order. First it should list by totals and if two or more have the same totals then it should list them in alphabetical order. Result: Richard Jason C. Steve S. Requi Jason C. Richard Steve S. Also if I wanted to added additional sheets to this formula how would I go about doing this as I tried {=INDEX('W1:W3'!B:B,MATCH(LARGE('W1:W3'!$AN$10:$AN $49+ROW($AN$10:$AN$49)/100000,ROWS($1:1)),'W1:W3'!$AN$10:$AN$49+ROW($AN$1 0:$AN$49)/100000,0)+ROW($AN$10)-1)} But I keep getting a value error. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting names and numbers in order with the highest total | Excel Worksheet Functions | |||
Alphabetical order possible? or not | Excel Discussion (Misc queries) | |||
why are my files out of alphabetical order? | Excel Discussion (Misc queries) | |||
sort last names by in alphabetical order | Excel Discussion (Misc queries) | |||
Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) |