how can I add the contents of the cell A to the cell B, if cell B is empty in MS Excel 2010?
My situation in detail:
- Column A (column with some empty and some non-empty values): AD
- Column B (no empty values here): I
Now I need Excel to fill the column AD with the values from the column I, if a value in the column AD is missing. Otherwise the original value from the column AD should remain.
Note: All columns contain text data (no numbers, currency etc.)
But this doesn't work as expected: it just throws a circular reference error and fills the column AD3 with "0" in spite of any other values.
Does anyone have an idea? Thank you.