counting names
I missed they are in 2 columns so concatenate them into a single column first
in C1 =A1&B1
Apply the formula to the concatenated column.
Mike
" wrote:
I have a two columns A with surname and B with first name, but entered
multiple times:
eg:
Smith, John
Smith, John
Smith, Arthur,
Rabbit, Peter,
Rabbit, Peter
Rabbit, Peter
What's the easiest way to total up the number of people there are? In
this case 3.
Thanks
|