Count Unique Values Using Two Columns of Data

Hello,

Thanks in advance for your help. Below I have a list of employees and a list of #'s showing the job function that they completed. I want to count the number of job functions completed by each employee without counting multiple times when they complete a job function more than once (unique values). So for the example seen below I need the formula to give me a result of 5 job functions completed for Doe, John.

A B
1 Employee Job Function
2 Doe, John 145729
3 Doe, John 145727
4 Doe, John 145725
5 Doe, John 145725
6 Doe, John 145723
7 Doe, John 145723
8 Doe, John 145721

D2: Doe, John

E2: =SUM(SIGN(FREQUENCY(IF(A$2:A$8=D2,B$2:B$8),B$2:B$8)))

Press Ctrl+Shift+Enter, not just Enter

SOLVED! Thank you!

You're Welcome!

I just realized that I am going to need to use "Calculate Sheet" to generate all of these numbers. With the amount of data in this file that could take awhile. Are there any other functions I could use that would get these same numbers but would not take so long to calculate? Maybe something other than an array function... or maybe I'm just dreaming. Thanks for the thoughts.