If a postal code doesn't match another line item for the same employee ID - check a box
I need to compare the postal code in two or more rows with the same Employee ID to make sure they match each other. If they don't then to check a box for Attention: Zip Code.
For instance, below, we have 4 line items for one person. The City is Atlanta and the State is GA and Postal code is 30339. Since there is also a line item that is Irvine CA 92606 I would need the box checked Attention: Zip Code for that because it needs to be reviewed.
Help Article Resources
Check out the Formula Handbook template!