Cells A14:BA14 all contain formulas. Only one of them will produce anything at a time. They all produce different text. I am trying for a formula to produce the cell value of the one that has text. For instance, if AW14 says "Silty clay", all of the other cells in the row will be blank. I'd...