Count unique numbers between dates with criteria on filtered sheet

Hi All,

I have a sheet that I need to count unique client numbers between two user inputted dates based on criteria in a client intention column - all on a sheet that is filtered for employee username. When the sheet is filtered, a table should show the filtered result. I've googled extensively and cannot find a version of "Count unique numbers between dates with criteria" that works for filtered sheets.

I've attached a sample file to try to illustrate the requirements. B2 & B3 are user inputted dates. B6 is a validation list of users (or all users) to allow filtering. The criteria to be counted are in D2:D7 and formulas to be in E2:E7. I'm really quite stuck! Can anyone please assist?

Many thanks,

Hi Jason.b75,

Thank you for your reply. Unfortunately your formulas do not appear to count unique client numbers. Apologies, perhaps this was because my explanation was not clear enough. I've created and attached a much clearer (I hope) set of examples to illustrate the desired outcome.

What I'm looking for is a count of unique client numbers with a specific item intention, on a filtered sheet, between two dates.

Many thanks,

Hi jason.b75,

Thanks for your time and the solution - super job, it works exactly as required! I've literally spent days on this!

Great idea on the filter criteria option as well. Filtering has always been the sticking point for a workable solution. And yes, B6 is the filter criteria/toggle.

Many thanks again!