How to use a formula to check if 1 PO contains 2 SO

[Uluru]

eg, How to use a formula to check if 1 PO contains 2 SO and is filed with color? Thank you
PO# SO#
123 456
123 789

[Glenn Kennedy]

I have absolutely no idea what you want... based on your cryptic description.

Please read the yellow banner (top), about sample sheets and provide a sample that meets its guidelines.

[Uluru]

I have absolutely no idea what you want... based on your cryptic description.

Please read the yellow banner (top), about sample sheets and provide a sample that meets its guidelines.

Want to check and colour out if the PO with 2 SO
Normally we assuthat 1 PO=1SO

[Glenn Kennedy]

Where is the sample sheet that meets the forum guidelines?

I do not want to play guessing games.

[NewYears1978]

I agree with Glenn that your explanation was a little confusing and that a sample file would help.

I think I understand what you want only because I had a similar thing with forms I use for my work.
Why not simply highlight duplicates with that built in function?

I also use a similar VBA macro in a file I use for the same reason, this will highlight dupliates with different colors so you can differentiate between them.

Please Login or Register  to view this content.

This assumes that Purchase Orders are in Column A and Sales Orders are in Column B.

Results are like this:
sample2.png