Hi guys, I have an excel sheet that has 100 odd headers, following some values, i am trying to extract all the headers that has value 1 or more than 1 in one cell . for example there are headers x,y,z , x has value 1 , z has value 2 , what i want to do is just put one formula that extract X,Z in one cell.
Can someone help me with the correct formula? Thanks.
Bookmarks