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