Kwnstantinos_M
New Member
- Joined
- Jun 12, 2018
- Messages
- 24
Hello,
I have 4 columns of data, like this:
<tbody>
</tbody>
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?
I have 4 columns of data, like this:
NE | NW | SE | SW | Prevailing |
45 | 30 | 22 | 31 | NE |
25 | 59 | 51 | 42 | NW |
71 | 44 | 21 | 18 | NE |
9 | 5 | 22 | 56 | SW |
<tbody>
</tbody>
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?