I am trying to come up with a formula that will put the data from column A in a Column C if there is data in column A - I have that part as IF(A1<>"",A1)
However, if column A is blank I want the data from Column B to be placed into Column C and am having trouble with the complete formula.
Any help would be great! TIA.
It could be
Try this formula out in cell C1:
or if you wanted to finish the formula the way you started, it would be:
Hope this helps!
@Sergei Baklan - Thanks! That worked.
You are welcome. As variant, if both A1 and B1 are numbers or blanks only that could be