CountIF bas

  • Thread starter Thread starter Larry Rouse
  • Start date Start date
L

Larry Rouse

What I am looking for is to count the occurances of
changes in text. The text being location names, which are
a combination of both alpha & numberical data.

So:

Location1
Location2
location3

I have over 1000 locations, I need something that will
count and tell me how many different locations are in the
list.

Thanks
 
This formula has developed over a long time here. I think it was Harlan
that presented the latest and most effective version:

=SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&""))
 
Back
Top