Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting names and numbers in order with the highest total Red Shoes Excel Worksheet Functions 1 June 23rd 06 09:23 AM
Alphabetical order possible? or not OSSIE Excel Discussion (Misc queries) 5 June 22nd 06 07:21 PM
why are my files out of alphabetical order? kwardja Excel Discussion (Misc queries) 2 June 19th 06 02:32 PM
sort last names by in alphabetical order Jackie Excel Discussion (Misc queries) 1 May 24th 06 08:45 PM
Formula to sort names in alphabetical order? Fredrik Jonsson Excel Discussion (Misc queries) 0 September 1st 05 04:33 PM


All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"