Hi Mark

With your headings in A1:Z1 and your numbers in A2:Z2
=INDEX(A1:Z1,MATCH(MAX(A2:Z2),A2:Z2))

Regards

Roger Govier


xxxMarkxxx wrote:
I need a function fo r the following:

In a given row of # values, I want to find the max. value and give the
associated text column heading in a new column. How do I do this??
Thanks