It's difficult to explain my question, but I'll try.

Example:

I have a spreadsheet with column headings of names of people and rows with
names of each of the 12 months for a particular year.

In each cell is the number of sales made by each person each month.

At the end of each "month" row I have a cell in which I calulate by formula,
for example, =MAX(B18:M18), the maximum number of sales for that month by a
particular person, say, John. IOW, it is a cell that gives the maximum
number of sales made by any one person that month. No problem there. But
either in that cell, or in another cell next to it, I want to automatically
place the /name/ of the person in the column heading who made the maximum
number of sales for that month. How do I do that? It probably is simple, but
I don't know the answer.

Thanks very much.

Ken