Show me in which column corresponds the max value

[Kwnstantinos_M]

Hello,

I have 4 columns of data, like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]NE[/TD]
[TD]NW[/TD]
[TD]SE[/TD]
[TD]SW[/TD]
[TD]Prevailing[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]30[/TD]
[TD]22[/TD]
[TD]31[/TD]
[TD]NE[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]59[/TD]
[TD]51[/TD]
[TD]42[/TD]
[TD]NW[/TD]
[/TR]
[TR]
[TD]71[/TD]
[TD]44[/TD]
[TD]21[/TD]
[TD]18[/TD]
[TD]NE[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]5[/TD]
[TD]22[/TD]
[TD]56[/TD]
[TD]SW[/TD]
[/TR]
</tbody>[/TABLE]

The first 4 columns contain numbers of wind data. In the fifth column I want to write a command, by which the name of the prevailing wind (namely the name of the column) will be returned as a result. For instance, in the 2nd row NE has the highest number, therefore NE is written in the fifth column etc. Do you have any ideas?

 

[Joe4]

Let's say that your data is in the range A1:D5.
Then, place this formula in E2 and copy down to E5:

=INDEX($A$1:$D$1,MATCH(MAX(A2:D2),A2:D2,0))

 

[Kwnstantinos_M]

It returns the maximum value instead of the name of the column.. I want to return the name of the column corresponding to the maximum value. Do you know I mean? Instead of return the highest value, to show me NE or NW etc.

 

[Joe4]

It returns the maximum value instead of the name of the column.. I want to return the name of the column corresponding to the maximum value. Do you know I mean? Instead of return the highest value, to show me NE or NW etc.

I know exactly what you are saying, and if you follow my assumptions, it DOES, in fact, return the direction and not the number.
My guess if you edited my formula, and didn't do it properly.

Let me know the EXACT range your data appears in, and then let me know the exact formula you are using (and what cell you are placing it in).

 

[Kwnstantinos_M]

Yes you are right.. I made a mistake. Your command is perfect. Thank you very much, and I'm sorry.. my mistake! Thanks again!

 

[Joe4]

No worries!
I am glad you got it working.