What happens if they all contain data?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Steve HKG" <Steve wrote in message
...
I am trying to provide a status result in cell A:10, of either A, B, C, D.

When cells A:1 and A:2 have information input into them the result should be
"A" in A:10.
When cells B:1 and B:2 have information input into them the result should be
"B" in A:10.
When cells C:1 and C:2 have information input into them the result should be
"C" in A:10.
When cells D:1 and D:2 have information input into them the result should be
"D" in A:10.

Can anyone advise? Sorry am new to excel!