Hello,
Got a bit of a crazy one, I have 8 cells (A1 - D1 & A2 - D2), cells A1 - D1 are column headers and contain no formulas, while cells A2 - D2 contain formulas that will either return a value or a blank cell. Only one of the A2 - D2 cells will have a value populated for each row. I'm looking for a formula that will determine which cell has a value in it and then return the value of that cells column header. For example, if cell B2 is the only cell populated the formula will return the value in cell B1.
Got a bit of a crazy one, I have 8 cells (A1 - D1 & A2 - D2), cells A1 - D1 are column headers and contain no formulas, while cells A2 - D2 contain formulas that will either return a value or a blank cell. Only one of the A2 - D2 cells will have a value populated for each row. I'm looking for a formula that will determine which cell has a value in it and then return the value of that cells column header. For example, if cell B2 is the only cell populated the formula will return the value in cell B1.