"Bruce Norris" wrote
Brilliant. That seems to work great.
.. I don't understand it, but it works.

Some clarifications ..

SUM(IF(LEN(rngPlaces)0,1/COUNTIF(rngPlaces,rngPlaces)))

The 1st part of the formula (above) returns the
count of all unique items in the range

SUM(--(COUNTIF(rngPlaces,rngPlaces)=1))

The 2nd part of the formula (above) returns the
count of unique items which appear only *once* in the range
(This count has to be subtracted from the 1st part of the formula
according to your specs)

So the net return (1st - 2nd) gives the desired result

What is the "--" for in the syntax?

In ... SUM(--(COUNTIF(rngPlaces,rngPlaces)=1))

The "--" is to coerce the TRUE / FALSE returns by the COUNTIF(...)
into 1's and 0's for SUM(...) to return the total

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----