I'm hoping this is an easy one. I just need to count the number of unique county names in a column. I'd like to do it without a helper column. Possible?
CountyName
Henry (1)
Jefferson (2)
Winston (3)
Jefferson (2)
Hale (4)
Shelby (5)
Marshall (6)
Tallapoosa (7)
Calhoun (8)
Pickens (9)
Talladega (10)
Etowah (11)
Covington (12)
Lauderdale (13)
Calhoun (8)
13 <-- Should be the result, because there are only 13 unique names.
Assuming data in Column A2:A30 range
=SUMPRODUCT((A2:A30<>"")/COUNTIF(A2:A30,A2:A30&""))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
you'll need to put the results somewhere obviously.
if the county names are in col A then this should work...
=countif(A1:A15,A1) in col B and it'll give you the results.
EDIT: now that i reread your post for the 5th time, I misunderstood what you wanted. And Alkey's post helped me see it.
His response is better than mine.
Last edited by Sam Capricci; 12-13-2013 at 10:29 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This works. Thank you!
Originally Posted by AlKey
Thank you for the feedback! Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks