Hi,
In C1,put
=if(A10,A1,B1)
and copy this down in column C.
Thank you,
K.S.Warrier

"Frank Kabel" wrote:

Hi
and what do you want to do with this information afterwards?

--
Regards
Frank Kabel
Frankfurt, Germany

GBH99 wrote:
How can I programme excel so that if Column A is filled in for a
value then it will ignore any values in Column B?