Hi,
I'm trying to compare two columns with numerals.
Compare column A against B.
If column A = 0, then answer is from column B
Then for the remaining data I wish to compare column A next to B, and only if the values aren't equal to each other, then grab column A answer, otherwise column B answer.
(And if they aren't equal it doesn't matter I just need the value.)
I'm having trouble writing the formula and would appreciate some help please.
Thank you,
I'm trying to compare two columns with numerals.
Compare column A against B.
If column A = 0, then answer is from column B
Then for the remaining data I wish to compare column A next to B, and only if the values aren't equal to each other, then grab column A answer, otherwise column B answer.
(And if they aren't equal it doesn't matter I just need the value.)
I'm having trouble writing the formula and would appreciate some help please.
Thank you,