COUNTA and COUNTIF IN SAME FORMULA

[Closed]
Report
Posts
2
Registration date
Thursday March 26, 2015
Status
Member
Last seen
March 27, 2015
-
So what I am trying to accomplish is this:

I want to count the text in Range (B1:b5) excluding duplicates, however only if the text in range(a1:a5) matches exactly for example listed below lets say Stephanie.

LSP Customer policy number
stephanie tom 1232
jessica jerry 8768
stephanie jack 87576
stephanie jack 9876987
jessica hank 9876769

So the correct formula should come back with the number 2. Driving myself crazy over this ugh.