How to compare two Rows?

[nature969]

Please help

I want a formula which can show me if A2=A3, say Yes, and if a4=a5 say yes.

thanks

 

[sitewolf]

you mean, say in column B.... =if(A2=A3,"Yes","No")? or something more

 

[Amanda Wilso]

=IF(A2=B2,"Yes","No")

=IF(A4=A5,"Yes","No")

 

[nature969]

you mean, say in column B.... =if(A2=A3,"Yes","No")? or something more

Thanks for your reply.
In column 2 I applied the formula. all good with the result.

Now I have an other question. I want to sort my data which only show me row 2 and row 3 and hide if row 3=row 4. see below

ID	Formula
M108620868376648	NO
M108620868376111	No
M108620868376649 <tbody> </tbody><colgroup><col></colgroup>	Yes
M108620868376649 <tbody> </tbody><colgroup><col></colgroup>	No
M108620868376650 <tbody> </tbody><colgroup><col></colgroup>	Yes
M108620868376650 <tbody> </tbody><colgroup><col></colgroup>	No

<tbody>
</tbody>

 

[nature969]

Do you mean I have to put two formula into One?

 

[nature969]

Can anyone help? I got what I want, but Now I have an other question. I want to sort my data which only show me row 2 and row 3 and hide if row 3=row 4. see below

ID	Formula
M108620868376648	NO
M108620868376111	No
M108620868376649 <tbody> </tbody>	Yes
M108620868376649 <tbody> </tbody>	No
M108620868376650 <tbody> </tbody>	Yes
M108620868376650 <tbody> </tbody>	No

<tbody>
</tbody>