Try the below in Row1 cell A1 and copy down. Please note that this is an
array formula. Within the cell in edit mode (F2) paste this formula and press
Ctrl+Shift+Enter to apply this formula. If successful in 'Formula Bar' you
can notice the curly braces at both ends like "{=<formula}"

=INDEX(1:1,MIN(IF(B1:E1<"",COLUMN(B1:E1))))

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

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