Flint Dianne
Jones Amber
Jackson Dorraine
Smith Laurel
Smith Lesley
Smith Lesley
Smith Lesley
Jones Amber
Jones Amber

If these are my names and I use any of the formulas suggested the result
returned is 5 and it should be 6??

Any suggestions??
"Domenic" wrote:

Try the following...

=SUM(IF(FREQUENCY(MATCH(A1:A10&B1:B10,A1:A10&B1:B1 0,0),ROW(INDIRECT("1:"&
ROWS(A1:A10))))0,1))

OR

=COUNT(1/FREQUENCY(MATCH(A1:A10&B1:B10,A1:A10&B1:B10,0),ROW (INDIRECT("1:"
&ROWS(A1:A10)))))

Both these formulas need to be confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Debbie wrote:

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.