I am working with excel.
I have almost two identical columns and I need some of the different results of the column at the right to be at the column at the left.
They look like this....
A B
Yes Yes
No No
No Maybe
Yes Yes
Yes Maybe
No NA
Yes Yes
No Maybe
Yes NA
No No
I need new column A that contains the "Maybe" and maintain the values of the A when is NA in the B column... So it should look like this....
A B C
Yes Yes Yes
No No No
No Maybe Maybe
Yes Yes Yes
Yes Maybe Maybe
No NA No
Yes Yes Yes
No Maybe Maybe
Yes NA Yes
No No No
I have tried different things with IF formula, Match formula and Vlookup formula, but I have not reach a solution.