Hello,
I'm trying to figure out which function to nest within the below to allow for counting of unique values in one column, contingent on a value in different column.
SUM(IF(FREQUENCY(MATCH(D7:D595,D7:D595,0),MATCH(D7:D595,D7:D595,0))>0,1))
Essentially, I'm trying to come up with a sumif like function, only to count unique values.
Example, column A contains the primary key, or Project code, column B contains the client code, and column C contains the salesperson assigned, with any particular client or salesperson having multiple project codes assigned. Is there a way to revise the above function to count number of unique client codes per salesperson?
Thanks in advance!
I'm trying to figure out which function to nest within the below to allow for counting of unique values in one column, contingent on a value in different column.
SUM(IF(FREQUENCY(MATCH(D7:D595,D7:D595,0),MATCH(D7:D595,D7:D595,0))>0,1))
Essentially, I'm trying to come up with a sumif like function, only to count unique values.
Example, column A contains the primary key, or Project code, column B contains the client code, and column C contains the salesperson assigned, with any particular client or salesperson having multiple project codes assigned. Is there a way to revise the above function to count number of unique client codes per salesperson?
Thanks in advance!