| 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. |
| 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 | |||
Threaded Mode
