| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the largest in a column
I have a datebase containing 2 columns. In one column I have a persons name
in the other column is a number associated with that name. I would like to search the column with numbers and find that largest number and the persons name associated with that number and they place that name and number in another cell. Example of names and numbers appear below. The answer can be in one column or two. Can this be done? Thanks in advance, Gordon Smith, George 230 Henry, Bill 210 Thomas, Frank 200 Answer: Smith, George 230 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
| Find a empty cell in next column | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
Threaded Mode
