Hi.
There are 3 cells and only one of them will ever have a value in it. I want a 4th cell to = whichever of these cells has a value.
For example Cell 1 is "Frog" so Cell 4 will be "Frog".
On another row Cell 3 is "Boat" so Cell 4 of this row will be "Boat".
Multiple columns in the same row would never be populated but if this were the case I'd expect an error or something similar...
Bookmarks