Compare 2 col with 2 col and find the different

[Hyakkivn]

Hi everyone !
I have an issue as below:
1. I have 2 sheets named: "code" and "Detail"
2. In sheet code, range("Q2:R-lastRow") store the base radians of vehicle route.
3. In sheet Detail, range("G2:H-lastRow") store the everyday-route of vehicles.
4. Q and G store departure point, R and H store destination.
I would like a solution that compare Gi:Hi with Qj:Rj. if there is/there are Gi:Hi that doesn't fit Qj:Rj, notice the position of that Gi:Hi. If every row fit, just tell" Every row is fit.
5. j = 2 to 250, i = 3 to 42000.
Thanks in advance

 

[Alex Blakenburg]

Couldn't you achieve that by just adding a column to the Detail sheet with Countifs and then filtering on that column for zero or not zero ?

=COUNTIFS(code!Q2:Q250,G3,code!R2:R250,H3)

 

[Hyakkivn]

=COUNTIFS(code!Q2:Q250,G3,code!R2:R250,H3)

Omg. I haven't thought about this. Haha..thank you so much. It solve my problem !!!

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.