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

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


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2