I have a list of thousands of customers in column A. Customers can be listed either once or more than once. If a customer is listed more than once, I want to compare their values in column B and make sure that they are consistent. See example below. Sales District for Customer A are not consistent. I would like to identify customers that do not have consistent values in column B. Please help.
Customer Sales district
A East
A East
A West
B East
B West
B East
C East
C East
D East
D West
E West
E West
F East
F East
G East
G West
H West
H West
I West
I East
J East
J East
K West
K West
L West
L East
M East
M West
N East
N East
O West
O East
P East
P East
Q East
R East
S East
S East
T East
U East
U East
Bookmarks