I am trying to have the header of the column (column name) appear in a cell next to the cell that has the uses the function MIN working with more than 2 numbers (more than 2 columns. I can attach an example to those who wish to help me, thanks

jklen

Assume you have this is F2

=MIN(A2:D2)

Then in G2, you could use a formala like this

=OFFSET(A2,-(ROW(A2)-1),MATCH(F2,A2:D2,FALSE)-1)

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"jklen" wrote in message
...
I am trying to have the header of the column (column name) appear in a
cell next to the cell that has the uses the function MIN working with more
than 2 numbers (more than 2 columns. I can attach an example to those who
wish to help me, thanks