Compare Two columns
 

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.

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.

Compare Two columns
 

One way:

=IF(AND(OR(AA26="O",AA26="U"),OR(AB26="O",AB26="U" )),"1","")

Regards

Trevor


"JavyD" wrote in message
...
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.

Compare Two columns
 

Thanks Marcelo, Thanks Trevor, Trevor's hit it right on the nail. it looks
the original I was working on, but I had the or trying to pick up the
AA26="O" or "U" together, I see you broke it apart.

Thanks both, this will make life easier.

"Trevor Shuttleworth" wrote:

One way:

=IF(AND(OR(AA26="O",AA26="U"),OR(AB26="O",AB26="U" )),"1","")

Regards

Trevor


"JavyD" wrote in message
...
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.

Compare Two columns
 

You're welcome. Thanks for the feedback


"JavyD" wrote in message
...
Thanks Marcelo, Thanks Trevor, Trevor's hit it right on the nail. it
looks
the original I was working on, but I had the or trying to pick up the
AA26="O" or "U" together, I see you broke it apart.

Thanks both, this will make life easier.

"Trevor Shuttleworth" wrote:

One way:

=IF(AND(OR(AA26="O",AA26="U"),OR(AB26="O",AB26="U" )),"1","")

Regards

Trevor


"JavyD" wrote in message
...
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.