I hope this can be done with a simple conditional statement:
I have columns A B C of data.
If the value of column B is False I would like column C to be populated with the corresponding values in column A.
A B C
123 True (blank)
456 False 456
789 True (blank)
abc False abc
If I can't use a formula I could create a macro. The dataset is small but I'll be using the formula as I create new worksheets.
Thanks.
I have columns A B C of data.
If the value of column B is False I would like column C to be populated with the corresponding values in column A.
A B C
123 True (blank)
456 False 456
789 True (blank)
abc False abc
If I can't use a formula I could create a macro. The dataset is small but I'll be using the formula as I create new worksheets.
Thanks.