formule ou manière de classer des données (tableau dynamique)

%3CLINGO-SUB%20id%3D%22lingo-sub-2321465%22%20slang%3D%22fr-FR%22%3Eformula%20or%20way%20to%20classify%20data%20(dynamic%20table)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321465%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20have%20to%20find%20out%20how%20many%20sports%20clubs%20each%20department%20in%20my%20database%20has.%20it's%20probably%20simple%20to%20do%20but%20I%20don't%20master%20the%20dynamic%20tables%20or%20the%20necessary%20formula.%3C%2FP%3E%3CP%3EI%20have%20about%205600%20entries%20(number%20of%20clubs)%3A%20one%20horizontal%20line%20per%20club%3C%2FP%3E%3CP%3Efor%20each%20club%20entry%20I%20have%20as%20columns%20used%20to%20do%20the%20math%3C%2FP%3E%3CP%3E-%20a%20Codep%20column%20(the%20membership%20department)%2C%3C%2FP%3E%3CP%3Ea%20column%20%22association%20number%22%20(linked%20to%20its%20department)%3C%2FP%3E%3CP%3Eexample%3C%2FP%3E%3CP%3Ecodep%2084%20%2F%20n%20association%20A08412345%20(the%20A%20is%20followed%20by%20the%20department)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20we%20have%20to%20be%20able%20to%20cross%20these%20two%20data%20(take%20all%20the%20club%20numbers%20starting%20with%20A084%20to%20see%20how%20many%20there%20are%20in%20the%20department%2084)%20and%20years%20in%20a%20row%20for%20all%20departments%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20help%20and%20explanation%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2321465%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2321889%22%20slang%3D%22fr-FR%22%3ERe%3A%20formula%20or%20way%20to%20classify%20data%20(dynamic%20table)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321889%22%20slang%3D%22fr-FR%22%3E%3CP%3EI%20found%20it!%20Thank%20you!!!%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044613%22%20target%3D%22_blank%22%3E%40VRBffepgv2021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour

je dois trouver combien chaque département de ma base de données possède de clubs sportifs. c'est sûrement simple à faire mais je ne maîtrise pas les tableaux dynamiques ou la formule nécessaire.

j'ai environ 5600 entrées (nombre de clubs) : une ligne horizontale par club

pour chaque entrée club j'ai comme colonnes servant à faire le calcul

- une colonne Codep (le département d'appartenance), 

une colonne "numéro de l'association" (liée à son département)

exemple

codep 84 / n association A08412345 (le A est suivi du département)

 

donc on doit pouvoir croiser ces deux données (prendre tous les numéros de clubs commençant par A084 pour voir combien il y en a dans le département 84) et ans de suite pour tous les départements

 

merci de votre aide et explication

2 Replies

@VRBffepgv2021 

Perhaps you may illustrate by sample file with only few records in each table. It's not clear how your data is structured, for example where are years, etc.