Counting Unique Values Across 2 Columns

Originally Posted by NBVC

Assuming data is in A2:B100, for example, try:

=COUNT(1/FREQUENCY(IF(A2:A100&B2:B100<>"",MATCH(A2:A100&B2:B100,A2:A100&B2:B100,0)),ROW(A2:A100)-ROW(A2)+1))

confirmed with CTRL+SHIFT+ENTER not just ENTER.

This seemed to work. It gave a value within the realm of possibility, but I am dealing with hundreds of names so it is hard to verify. I trust you, though, and it makes sense, so thanks a lot for the quick and accurate help!