How to count the number of occurrence of values in a column?
For example we have a list of towns in the A column. Among this towns, some are alone, others are in collectivity groups (towns groups, agglomeration communities), that we put in column B.
So, we have n towns, and n-x collectivities. We know our n (=3000) but we would like to know our (n-x).
What is the good formula ?
Here is a suggestion :
Note: Commissions may be earned from the links above.
This page contains references to products from one or more of our advertisers. We may receive compensation when you click on links to those products. For an explanation of our advertising policy, please visit this page.