No, there are 5 unique values. Check again. I know my
formula works - I didn't try Domenic's, but I'm sure they
do.

Jason

-----Original Message-----
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:B10,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 <89EA2BA5-9511-4E56-8D75-
,
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.

.