Counting Unique Text Fields
 

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?
--
MWALL

Counting Unique Text Fields
 

Try this:

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


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

XL2002, WinXP


"MWall" wrote:

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?
--
MWALL

Counting Unique Text Fields
 

Hi Ron,

I tried this on one of my worksheets and it dragged it to a crawl every time
it went through a computation :(

"Ron Coderre" wrote:

Try this:

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


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

XL2002, WinXP


"MWall" wrote:

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?
--
MWALL

Counting Unique Text Fields
 

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)



"LouP" wrote in message
...
Hi Ron,

I tried this on one of my worksheets and it dragged it to a crawl every
time
it went through a computation :(

"Ron Coderre" wrote:

Try this:

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


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

XL2002, WinXP


"MWall" wrote:

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?
--
MWALL