Hello,

I've been beating my head in and reading every related thread I can on this issue. In my data dump I basically have a row containing 6 pieces of information, and I'm only concerned with two. I need a count of unique tasks performed by one resource. Column A would have a list of resource names, including duplicates as this is raw data dump, and column B would have a task performed by that person per line item. I'd like to be able to write a formula that said given this one person as criteria how many unique tasks did they perform? I've attached a sample spreadsheet but keep in mind the actual is tens of thousands of entries long and ever expanding so I can't make it a static table.

Unique List Sample.xlsx