count non duplicate invoice numbers for a specific employee

[bacardi510]

I have a spread sheet that I am trying to determine how many invoices a specific employee is responsible for. There are many duplicate invoice numbers. Is there a way to use FORMULA to return the number of unique invoice numbers for a specific employee? Invoice numbers are in Column B and the employees name is in column G. Please keep in mind my actual sheet has thousands of lines and hundreds of employees so sorting will not work for me as I am pulling lots of other data from it. I need a quick way to get these figures. I have uploaded an example worksheet. Thank you for your help figuring this out!

[Ron Coderre]

Using your posted workbook

This formula, copied down, returns the count of unique invoices for the referenced name

H10: =SUMPRODUCT(ISNUMBER(SEARCH(G10,$G$2:$G$6))/(COUNTIFS($G$2:$G$6,G10,$B$2:$B$6,$B$2:$B$6&"")+($G$2:$G$6<>G10)))

Is that something you can work with?

[bacardi510]

Perfect!! Thank you so much!!