Counting unique instances of a text string

P

Paul S

Is it possible to count unique instances of a text string

In column A (200+ entries) I have a list of Stores and Regions and wan
a formula to count the number of regions

Region A
Store X
Region B
Store Y
Region A
Store X
Region C

So in the simplified example above the count of unique regions would b
 
C

Claus Busch

Hi Paul,

Am Fri, 15 Feb 2013 18:04:58 +0000 schrieb Paul S:
Is it possible to count unique instances of a text string

In column A (200+ entries) I have a list of Stores and Regions and want
a formula to count the number of regions

Region A
Store X
Region B
Store Y
Region A
Store X
Region C
Click to expand...

try:
=SUMPRODUCT((LEFT(A1:A300,6)="Region")/COUNTIF(A1:A300,A1:A300&""))


Regards
Claus Busch
 
P

Paul S

Claus said:
Hi Paul,

Am Fri, 15 Feb 2013 18:04:58 +0000 schrieb Paul S:
-

try:
=SUMPRODUCT((LEFT(A1:A300,6)="Region")/COUNTIF(A1:A300,A1:A300&""))


Regards
Claus Busch
Click to expand...

Thanks Claus that worke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Current Region in a formula 1
a data validation list that contains a list of named ranges - not alist from a named range 1
Unique count formula 3
Counting instances of Specific column entry combinations 1
Counting unique values based on 2 columns 3
count(if(... using array formula: can I use a named range in my ca 1
Counting Unique occurences of text in a column 12
Finding count of unique number within a specific criteria? 7

Top