Highest then alphabetical order By Names?

K

Killer

Hey All trying to get this formula working correctly:

{=INDEX('W1'!B:B,MATCH(LARGE('W1'!$AN$10:$AN$49+ROW($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.

Require:

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$10:$AN$49)/100000,0)+ROW($AN$10)-1)}

But I keep getting a value error.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top