Values in multiple columns into one column

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi everyone,

I have a spreadsheet with values in multiple columns
where for instance col A is blank colb or c or d won't
be...there will be something in one where the others are
empty. I need to create a column with all the values
together. Tried using the following formula but it
doesn't seem to work... the values are all dates..

=IF(O2=" ",N2,IF(N2=" ",K2,IF(K2=" ",J2,O2)))

Can anybody help!!

Cheers
Dan
 
Hi
can you provide some example data for your columns (plain
text - no attachment please) and your desired result for
each row
 
Back
Top