This will get you the column number for the max value in A3:F3:
=COLUMN(INDIRECT(CELL("ADDRESS",OFFSET(A1,0,MATCH( MAX(A3:F3),A3:F3,0)-1))))

=CELL("ADDRESS",OFFSET(A1,0,MATCH(MAX(A3:F3),A3:F3 ,0)-1))))
will get you the address of the cell. You can use string functions to
isolate the column letters.

Dan

"skier464" wrote:

I have a very large spreadsheet that I'm using the max and min functions
on. I need to know which column that the max and min are in. For example I
have

Column A B C D E F
Row 1 1 2 3 4 5 6

THe max function will tell me that the max is 6. What I need is it to tell
me the Max is 6 in Row F.

How do i do this?

Thanks,