Counting Unique Text Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to count a text list with many duplicates. I am just trying to
count these unique text fields. I tried using =SUM(1/COUNTIF(B1:B17,B1:B17))
but this just seems to count numbers and not text.

Is there an easy way to do this?
 
Try this:

=SUMPRODUCT((B1:B17<>"")/COUNTIF(B1:B17,B1:B17&""))


Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
Hi Ron,

I tried this on one of my worksheets and it dragged it to a crawl every time
it went through a computation :(
 
I suspect that the formula you posted:
=SUMPRODUCT((B1:B17<>"")/COUNTIF(B1:B17,B1:B17&""))
didn't cause the problem, unless it was copied hundreds (thousands?) of
times or it referenced a large range. Is that true?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)
 
Back
Top