A | B | C | D | E | Result |
1 | 1 | 1 | 0 | 0 | C |
1 | 0 | 0 | 1 | 0 | D |
0 | 0 | 1 | 0 | 1 | E |
0 | 1 | 0 | 1 | 0 | D |
<tbody>
</tbody>
Like in the table above. I want to lookup the value in each row and return the header name which is the most right number "1" is located.
I know that we should use the index and match but I am not sure how to find "position of the most right number 1 located"