One way:

=SUMPRODUCT(--(MATCH(Fname&Lname,Fname&Lname,0)=ROW
(INDIRECT("1:"&ROWS(Fname)))))

where "Fname" is the range for first names and "Lname" is
the range of last names.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi I have first and last names in 2 columns and I need
to count the number of
unique people. It's already a busy worksheet and would
rather not have to
filter and move to another worksheet. Any suggestions?
Thanks.
.