| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning a value in one cell based on the criteria of another cel
I'm sure this is possible, just not able to figure it out right now. Here is
a basic spreadsheet w/ names in one column, and numbers in the next. A B C Name Average Mark 875 Paul 823 Tim 146 Gary 166 Highest: 875 The user would like to not only return the highest average on that last line, but also the name. For example we want it to read Mark 875 in that last line. Getting the 875 is easy using the =max, having it then return the name next to it is not as easy. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning all values based on 2 criteria... | Excel Discussion (Misc queries) | |||
| Returning contents of a cell based upon the minimum value in a ran | Excel Worksheet Functions | |||
| Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
| returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
| returning a value based on mulitple criteria | Excel Worksheet Functions | |||
Threaded Mode
