functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
I am trying to have the header of the column (column name) appear in a
Click to expand...
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
 
Back
Top