Return cell A, if blank return B if blank return cell C etc...
I need to return the first cell filled with text in a list of cells. The cells are on different sheets. It works with two cells using
=if(Sheet2!a1="",Sheet3!a1, Sheet2!a1) but I have 8 cells I need in the formula.
https://www.excelforum.com/sho....wthread.php?t=142407
Discover the world at Altruu, The Discovery Engine