Hello everyone,
I need to count occurrences of text in relation to two columns, ie:
Column A has the names of all companies present in the municipalities of column B, but the criterion should be the column C, with counties already filtered.
The result I seek is: how many companies there are in each municipality (count only once each company in each city).
I uploaded the table here: http://www.sendspace.com/file/nfennx
I do not know what function to use, help!
Best to all
Ludmila
posted wrong here, sorry! I did not find how to delete moreover...
Well, I'm Ludmila, besides a little clumsy, I'm MA student in Geography and I have been using excel a lot to organize my databases ... I live in Brazil, we have 5565 municipalities, then I get dizzy with so much information to check
Not an expert in excel, but who want tips in cartography or geography I'll be glad to help!
It's Ok, thank you for joining the community.
Moderator's Note: To other mod's started new thread , not to move this thread. thanks.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks