View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Bruce Norris" wrote...
....
I want a formula in another cell to count how many values (text) appear
more than once in the range.

So...
- Values that appears only once in the list: Don't count.
- Values that appears more than once in the list: Count the value as 1.
- Blank cells: Don't count.

....

Another alternative,

=SUMPRODUCT((Rng<"")*(COUNTIF(Rng,Rng)1)/(COUNTIF(Rng,Rng)+(Rng="")))