View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kirstin Kirstin is offline
external usenet poster
 
Posts: 5
Default 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?