CountIF bas

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
 
S

Stephen Dunn

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&""))
 

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

What If Scenario and/or Pivot Table 0
How do I average every 3rd cell in a column of a spreadsheet? 3
Weighting Results to obtain an overall rank 1
multiple lookups and filtering 0
Simple Navigation Macro 3
Using <= in countifs statement 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Tex box Array 6

Top