I have 2 columns, Vendor and Tax Code. Ideally, a vendor would only use one code. However, exceptions may occur. I need to display the total number of exceptions. So if I have 10 vendors and 3 of them use more than one tax code, I need to display 3 as my answer. The difficulty is that the data is structured like this:
Vendor Code Amount
ABC X1 100
ABC X2 150
DEF X1 120
DEF X2 130
GHI X1 115
ABC X3 130
In this example, Vendor ABC uses 3 tax codes, and Vendor DEF uses 2 codes. So the result should be 2 exceptions.
Any ideas?
