Display Column Header Next to Values

[RedPed]

Hi,

I have data where I require the column header displaying next to some Max/Large value results

For example I am using the formula =MAX(R3:AS3) to bring back the max value in range R3:AS3 showing in cell AZ3 and in cell BA3 I would like the column header from where the max value was listed

Any suggestions or help appreciated

 

[Fluff]

Which row are the headers in?

 

[RedPed]

Which row are the headers in?

Row 2

 

[Fluff]

Ok, how about

=index(r2:as2,match(az3,r3:as3,0))

 

[RedPed]

Ok, how about

=index(r2:as2,match(az3,r3:as3,0))

Perfect, much appreciated

 

[Fluff]

You're welcome & thanks for the feedback.