Forum Discussion
Occurences of different words or terms in a spreadsheet
Hello, my users spreadsheet has 70 names from 50 structures and 30 countries. I have tried pivot tables to count how many different structures and countries I have, can't do this automatically though. Would you have a way? Thanks infinitely, Jc
8 Replies
Jc_Fadot Perhaps you can upload a file that accurately represents the structure (with sample data) of the spreadsheet you are talking about. If the information isn't confidential, why not upload the entire file?
- So, here is a similar spreadsheet, I would like to make several statistics out of it: how many structures/individuals of level 1/2/3, from how many countries, from different domains.
To count how many in Tech, Art, from France, etc., this I can do, with filters, etc. What I cannot achieve is make statistics of similar occurrences. What I get for example is how many structures from, say, Canada, and what I want but can't get is how many structures from different countries/how many countries are represented. Thanks infinitely in advance!Jc_Fadot Not sure I understand what kind of statistics you are trying to prepare, but perhaps the examples I added to you workbook get you started.
Hello Riny_van_Eekelen Yes, it is highly confidential, so I cannot share. I will try to make an avatar of its structure
