Hi

I am new to this Forum and hope somebody can help me. I need to count unique values based on another column example below

Code Type
N1234 NTU
N1234 NTU
N1234 BYU
N1234 BYU
N6789 NTU
N8974 BYT
B8974 BYT

Code and type vary - I want to count the unique codes based on the type so for instance they would be 2 N1234 and not 4 because they are two types present.

Can anybody help