View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BigBuck98
 
Posts: n/a
Default 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