Compare Two columns
Hi Javy
try it
if(and((aa12="O");(ab12="O"));1;if(and((aa12="U"); (ab12="U"));1;if(and((aa12="O");(ab12="U"));1;if(a nd((aa12="U");(ab12="O"));1;""))))
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"JavyD" escreveu:
Hello,
I tried to figure this out, seems to me that I'm getting close
I need the formula to look at column AA see if it says O or U, then look at
Column AB and see if it says O or U, then if they both meet this criteria,
then return 1 in AC,
this is what I have so far,
=IF(OR(AA26={"O","U"},AB26={"O","U"}),"1",""), I'm probably off, but it
seems to have started to do something. I was using the And function, but
running out of time.
Regards, thanks to all in advance.
|