Hi

I have four columns of data BCDE I want to combine into column A. I want to
say if column B is blank then show column C then if column C is blank then
show column D. It is important that it works in this order as thed ata refers
to dates i.e. last week, last month, last year, over a year.

Can anyone help?

Thanks