Hello Guys,
I have a Data set which is a bit like this
Product Sales Person
A Mr Smith
A Mr Smith
A Mr Smith
B Mr Brown
C Mrs Pink
D Mr Smith
What i am trying to do is count how many Products Mr Smith has, if i use the simple count ifs then i would get 4 when the answer is 2, I believe i need...