Excel: Formula to return column header

I have a table of data and need a formula to find the minimum in that row and return the text that appears in that column's header. For example say the min occurs in the 3rd column of a named range, I want the text that appears in the first cell of that 3rd column. Thanks,

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of February 06, 2003.

For more resources for Microsoft Excel