| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuance of last post on highest #
I received the following formula to solve my excel problem. Thiis formula
worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continuance of last post on highest #
Try this array formula** :
Assuming you enter this formula in F12. =INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0)) Copy down as needed ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Randy" wrote in message ... I received the following formula to solve my excel problem. Thiis formula worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continuance of last post on highest #
Thank-you unfortunately it returns the result "N/A". The formula looks good
but it does not bring back the result. Thx for the help any new ideas would be greatly appreciatted "T. Valko" wrote: Try this array formula** : Assuming you enter this formula in F12. =INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0)) Copy down as needed ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Randy" wrote in message ... I received the following formula to solve my excel problem. Thiis formula worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continuance of last post on highest #
Try this array formula** :
** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Did you enter the formula as an array? It works. Trust me! -- Biff Microsoft Excel MVP "Randy" wrote in message ... Thank-you unfortunately it returns the result "N/A". The formula looks good but it does not bring back the result. Thx for the help any new ideas would be greatly appreciatted "T. Valko" wrote: Try this array formula** : Assuming you enter this formula in F12. =INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0)) Copy down as needed ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Randy" wrote in message ... I received the following formula to solve my excel problem. Thiis formula worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continuance of last post on highest #
Screencap:
http://img146.imageshack.us/img146/3742/sortus9.jpg -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this array formula** : ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Did you enter the formula as an array? It works. Trust me! -- Biff Microsoft Excel MVP "Randy" wrote in message ... Thank-you unfortunately it returns the result "N/A". The formula looks good but it does not bring back the result. Thx for the help any new ideas would be greatly appreciatted "T. Valko" wrote: Try this array formula** : Assuming you enter this formula in F12. =INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0)) Copy down as needed ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Randy" wrote in message ... I received the following formula to solve my excel problem. Thiis formula worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continuance of last post on highest #
excellent thank-you. I am so happy!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
"T. Valko" wrote: Screencap: http://img146.imageshack.us/img146/3742/sortus9.jpg -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this array formula** : ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Did you enter the formula as an array? It works. Trust me! -- Biff Microsoft Excel MVP "Randy" wrote in message ... Thank-you unfortunately it returns the result "N/A". The formula looks good but it does not bring back the result. Thx for the help any new ideas would be greatly appreciatted "T. Valko" wrote: Try this array formula** : Assuming you enter this formula in F12. =INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0)) Copy down as needed ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Randy" wrote in message ... I received the following formula to solve my excel problem. Thiis formula worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Continuance of last post on highest #
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Randy" wrote in message ... excellent thank-you. I am so happy!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! "T. Valko" wrote: Screencap: http://img146.imageshack.us/img146/3742/sortus9.jpg -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this array formula** : ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) Did you enter the formula as an array? It works. Trust me! -- Biff Microsoft Excel MVP "Randy" wrote in message ... Thank-you unfortunately it returns the result "N/A". The formula looks good but it does not bring back the result. Thx for the help any new ideas would be greatly appreciatted "T. Valko" wrote: Try this array formula** : Assuming you enter this formula in F12. =INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0)) Copy down as needed ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Randy" wrote in message ... I received the following formula to solve my excel problem. Thiis formula worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| This is my Third Post Please Help !!!!!! | Excel Discussion (Misc queries) | |||
| post | Excel Discussion (Misc queries) | |||
| Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) | |||
Linear Mode
