Hello,

Apologies, but our servers don't allow uploads/downloads to/from this site. I hope my explanation will suffice!

I have a table of data and a separate summary table in which I want to return a value from the following.

I my data table, in column A are client names, in column B are months expressed as a number and in column C are years.

I am trying to return a count of unique values in column A:A when meeting a specific month (B:B) and a specific year (C:C). There can be multiple instances where one client name can appear within a specific month & year.

The summary table has a row referencing months and a cell to reference the year. I cannot have an exhaustive list of client names to reference as the number can increase or decrease at any time.

Thus far i have been trying various types of FREQUENCY formulae, coupled with COUNTIFS and IF statements, but I only ever manage to get a count, not a count of UNIQUE names.

I hope someone can help! Thanks in advance!