I have a matrix of numbers and the matrix has column header -- say like this:
a b c d e f 0 0 0 1 0 0 0 0 1 0 0 0
What I want to do is to search for each row for the element 1 and return its column header. For example if I scan the first row, I should return 'd'. Similarly if I scan the second row, I should return 'c'. Which combination of formula works good here?