| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Displaying contents of adjacent cells.
I have a list of scores on a rewards scheme sheet. adjacent to these scores
are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
|
#2
|
|||
|
|||
|
This will work, but it will get the name of the first matching Max sco
=INDEX(A1:A16,MATCH(G12,B1:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... I have a list of scores on a rewards scheme sheet. adjacent to these scores are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
|
#3
|
|||
|
|||
|
Try this:- =INDEX(A1:A16,MATCH(G12,B1:B16,0)) One problem, if you have more than one person with the same score, it will only display the first one in the list, if this won't happen, it shouldn't be a problem -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=390513 |
|
#4
|
|||
|
|||
|
Can't get this to work. Its returning names but not the correct ones.
to clarify.... names are in A5:A15, scores in B5:B16, max score displayed through "=MAX(B5:B16)" in B28. I want the name that matches the score displayed in B28 to appear in B27. Similarly i'm gonna be using the same thing for the score displayed in B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges C/D5:C/D16. presume it would be easy to change cell numbers. "Damon Longworth" wrote: This will work, but it will get the name of the first matching Max sco =INDEX(A1:A16,MATCH(G12,B1:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... I have a list of scores on a rewards scheme sheet. adjacent to these scores are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
|
#5
|
|||
|
|||
|
Try:
=INDEX(A5:A16,MATCH(B28,B5:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... Can't get this to work. Its returning names but not the correct ones. to clarify.... names are in A5:A15, scores in B5:B16, max score displayed through "=MAX(B5:B16)" in B28. I want the name that matches the score displayed in B28 to appear in B27. Similarly i'm gonna be using the same thing for the score displayed in B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges C/D5:C/D16. presume it would be easy to change cell numbers. "Damon Longworth" wrote: This will work, but it will get the name of the first matching Max sco =INDEX(A1:A16,MATCH(G12,B1:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... I have a list of scores on a rewards scheme sheet. adjacent to these scores are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
|
#6
|
|||
|
|||
|
tried this one, but its still not returning the correct name. seems to
generate the last on the list, which isnt the highest value. "Damon Longworth" wrote: Try: =INDEX(A5:A16,MATCH(B28,B5:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... Can't get this to work. Its returning names but not the correct ones. to clarify.... names are in A5:A15, scores in B5:B16, max score displayed through "=MAX(B5:B16)" in B28. I want the name that matches the score displayed in B28 to appear in B27. Similarly i'm gonna be using the same thing for the score displayed in B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges C/D5:C/D16. presume it would be easy to change cell numbers. "Damon Longworth" wrote: This will work, but it will get the name of the first matching Max sco =INDEX(A1:A16,MATCH(G12,B1:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... I have a list of scores on a rewards scheme sheet. adjacent to these scores are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
|
#7
|
|||
|
|||
|
Is there a match? Try adding the False argument:
=INDEX(A5:A16,MATCH(B28,B5:B16,0)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... tried this one, but its still not returning the correct name. seems to generate the last on the list, which isnt the highest value. "Damon Longworth" wrote: Try: =INDEX(A5:A16,MATCH(B28,B5:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... Can't get this to work. Its returning names but not the correct ones. to clarify.... names are in A5:A15, scores in B5:B16, max score displayed through "=MAX(B5:B16)" in B28. I want the name that matches the score displayed in B28 to appear in B27. Similarly i'm gonna be using the same thing for the score displayed in B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges C/D5:C/D16. presume it would be easy to change cell numbers. "Damon Longworth" wrote: This will work, but it will get the name of the first matching Max sco =INDEX(A1:A16,MATCH(G12,B1:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... I have a list of scores on a rewards scheme sheet. adjacent to these scores are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
|
#8
|
|||
|
|||
|
Thanks mate, there was no match. but it seems the 0 helped, why is this?
"Damon Longworth" wrote: Is there a match? Try adding the False argument: =INDEX(A5:A16,MATCH(B28,B5:B16,0)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... tried this one, but its still not returning the correct name. seems to generate the last on the list, which isnt the highest value. "Damon Longworth" wrote: Try: =INDEX(A5:A16,MATCH(B28,B5:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... Can't get this to work. Its returning names but not the correct ones. to clarify.... names are in A5:A15, scores in B5:B16, max score displayed through "=MAX(B5:B16)" in B28. I want the name that matches the score displayed in B28 to appear in B27. Similarly i'm gonna be using the same thing for the score displayed in B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges C/D5:C/D16. presume it would be easy to change cell numbers. "Damon Longworth" wrote: This will work, but it will get the name of the first matching Max sco =INDEX(A1:A16,MATCH(G12,B1:B16)) -- Damon Longworth Don't miss out on the 2005 Excel User Conference Sept 16th and 17th Stockyards Hotel - Ft. Worth, Texas www.ExcelUserConference.com "MikeyB" wrote in message ... I have a list of scores on a rewards scheme sheet. adjacent to these scores are the names of the record holders. IF scores are in B1:B16 the names are in A1:A16. I've used the max feature to find the max score and display in cell G12. I would like the name of the record holder to appear in cell G11 automatically. how do i do this? Any help would be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Contents of adjacent cell from a function | Excel Worksheet Functions | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
| Clear Contents - NonBold cells | Excel Discussion (Misc queries) | |||
| Literally displaying imported cells with and tags | Excel Discussion (Misc queries) | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Linear Mode
