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

[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.

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

 

[Frank Kabel]

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)