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,