Luanne wrote:
My data are in 19 columns and 600 rows. I need to find the minimum value in
each row. At the top of the columns are descriptions (e.g. Pen A, Pen B...).
I want to see which column ("Pen X") the minimum for that row came from. I
can get the minimum value in the row using min(), but it is the min value I
need, but the column name that has that value. I have searched for two hours
and cannot figure out how to do this! Can anyone help?

Thanks.

Assuming your data, including the column headings, begins in Cell A1 in
a range named "dataRange", you can insert the following formula in Cell
T2 and copy down:

=OFFSET($A$1,0,MATCH(MIN(INDEX(dataRange,ROW(A2),0 )),INDEX(dataRange,ROW(A2),0),0)-1)

Alan Beban