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!
{=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!