Using a concatenate formula to count unique values

[braydon16]

I have two columns of data that I need to analyze by counting the number of unique values. I assumed it would be easiest to perform a concatenate function in the sumproduct formula, but I'm struggling with it.

A sample of the data would be in column A there are client names, and in column B there are tasks. It's possible to have a task completed for a client more than once. So, if the client has the same task done twice, I'd like to only count it once. In this useless little example, I'd like to count Bob - Rig as 1.

Column A Column B
Bob Rig
Mark Call
Bob Rig
Bob Call

Thank you in advance for any assistance you an provide!

[DonkeyOte]

You could use:

Please Login or Register  to view this content.

modify to suit but keep ranges as lean as possible

(you could also use a Frequency Array)