Count Unique Names when in Two Colums

[gkitt80]

Hello All,

I need to count the number of times a unique name shows up in a table of data. The issue I am having is the names are split up into 2 columns, "LastName" and "FirstName." Obviously, some last names are very common, and thus if I only counted the number of unique last names I wouldn't get an accurate number. Any help would be much appreciated.

 

[facethegod]

so if your first and last names are in to columns say A and B then in C

try this and drag down

=A1&B1

then in D1 try this and confirm w/ ctrl + shift + Enter, not just enter

=SUM(1/COUNTIF(C1:C9,C1:C9))

 

[Aladin Akyurek]

Hello All,

I need to count the number of times a unique name shows up in a table of data. The issue I am having is the names are split up into 2 columns, "LastName" and "FirstName." Obviously, some last names are very common, and thus if I only counted the number of unique last names I wouldn't get an accurate number. Any help would be much appreciated.

Given A2:B7...

Control+shift+enter:

=SUM(IF(FREQUENCY(IF($B$2:$B$7<>"",
                   MATCH("~"&$A$2:$A$7&"-"&$B$2:$B$7,
                              $A$2:$A$7&"-"&$B$2:$B$7&"",0)),
                   ROW($B$2:$B$7)-ROW($B$2)+1),1))