Hello

Hoping someone can help. I have the following formula

=COUNTIFS(Sheet1!$Y:$Y,Sheet1!$Q:$Q,G$6)

Column Y contains 100 of names but I only want to count the unique number. How can I change this formula?

Thanks in advance

Dan