After some tinkering, this worked VERY well. Thank you VERY much. This
saved me hours of work.

Regards.
--
Anthony


"Lars-Ã…ke Aspelin" wrote:

On Tue, 3 Feb 2009 11:58:03 -0800, Anthony
wrote:

Thank you. Sorry for lack of clarification. In my example, it is the
A,B,C,D, etc...not the header.


Does that mean that 1,2,3 to the left also are just data and not the
row numbers?
Maybe better to use some other data in the example...

So, if this is your table

Alfa Bravo Charlie Delta Echo
data1 1 1 3 4 5
data2 1 2 1 4 5
data3 1 2 3 4 1

try the following formula

=INDEX(A$1:F$1,MAX(COLUMN(B:F)*(B2:F2=MIN(B2:F2))) )

For row2, with "data1" it will return "Bravo"
For row3 it will return "Charlie"
For row4 it will return "Echo"

Note: The formula is an array formula that should be confirmed with
CTRL+SHIFT+ENTER rather than just ENTER.

Lars-Ã…ke