| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference between rows, not columns
To simplify:
With a list of names in column A and scores in column B, I know using =INDEX(A:A,MATCH(MAX(B:B),B:B,FALSE,)1) I can see who has the highest score. My problem is, I want to do the same thing but across rows so that in the example the names would be in row 1 with the scores in row 2. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference between rows, not columns
With names in Row 1 and marks in row2 try the below
=INDEX(1:1,MATCH(MAX(2:2),2:2,FALSE)*1) If this post helps click Yes --------------- Jacob Skaria "Darren" wrote: To simplify: With a list of names in column A and scores in column B, I know using =INDEX(A:A,MATCH(MAX(B:B),B:B,FALSE,)1) I can see who has the highest score. My problem is, I want to do the same thing but across rows so that in the example the names would be in row 1 with the scores in row 2. Any help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Reference between rows, not columns
Thankyou so much.
"Jacob Skaria" wrote: With names in Row 1 and marks in row2 try the below =INDEX(1:1,MATCH(MAX(2:2),2:2,FALSE)*1) If this post helps click Yes --------------- Jacob Skaria "Darren" wrote: To simplify: With a list of names in column A and scores in column B, I know using =INDEX(A:A,MATCH(MAX(B:B),B:B,FALSE,)1) I can see who has the highest score. My problem is, I want to do the same thing but across rows so that in the example the names would be in row 1 with the scores in row 2. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamically reference the rows and columns as R78C15 | Excel Programming | |||
| Rows to Columns on reference | Excel Worksheet Functions | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
| how do i reference multiple rows/columns with one function? | New Users to Excel | |||
| Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
Hybrid Mode
