| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
display the value of a cell adjacent to the cell with max value
I have a very large spreadsheet that is constantly being added to. I have a
function that displays the max value of a particular column, but I also want to display the name that coincides with it. Since the name is located in a different column but same row number, is there a way to display it? (e.g. A2="Mark", B2=97.8) Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| excel tab key to move to right adjacent cell | Excel Discussion (Misc queries) | |||
| Display cell value on a chart. | Charts and Charting in Excel | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| display web pix in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
