Want to find max in a range then return a name from a cell

  • Thread starter Thread starter Pavavion
  • Start date Start date
P

Pavavion

The spreadsheet has 5 people each person has a list describing thei
sales performance.

Each has their highest sale, highest over cost sale etc.

I have a table with a describtion highest sale, highest over cost sal
etc.

I want the cell beside each title to calcute who has the highest figur
and place their name in this cell.

:confused: I have a spreadsheet with lists containing highest sale
highest average sale etc. What I want to do is create a formula tha
will find the max value within a list please note these values ar
spread out and do not run on the spreadsheet side by side or one afte
the other) and display a name from a different cell, depending on i
that is the highes
 
Hi
you may give some more details. e.g.
- in hwat range are your values
- in hwat range is the corresponding name

you may give some example data (plain text - no attachment
please)
 
Back
Top