Need help with a formula!

[Benny RC]

Hi,

I have 2 columns. In each row either both columns are blank, or only one of the columns has a text or a number. I am trying to have 3rd column with any number or text from either of the columns. I am using the following formula but it is wrong:

=IF(AND(ISBLANK(C1),ISBLANK(D1)),"",IF(OR(ISTEXT(C1),ISNUMBER(C1)),C1,IF(OR(ISTEXT(D1),ISNUMBER(D1),D1))))

I would appreciate any suggestions!

Thanks,

Benny

 

[Haseeb Avarakkan]

Welcome to the board...!


Try,

=IF(COUNTA(C1:D1),LOOKUP(2,1/(C1:D1<>""),C1:D1),"")

This will show the last non blank cell in C1:D1