Nov 22 2021 11:17 PM
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
Nov 22 2021 11:31 PM
@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?
Nov 23 2021 12:06 AM
Hello @Riny_van_Eekelen Yes, it is highly confidential, so I cannot share. I will try to make an avatar of its structure
Nov 23 2021 12:19 AM
Nov 23 2021 12:20 AM
Nov 23 2021 12:30 AM
@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.
Nov 23 2021 12:40 AM
Nov 23 2021 12:54 AM - edited Nov 23 2021 02:06 AM
@Jc_Fadot Sorry! I don't follow. Can you, on the basis of the sample, manually create the reports you want to achieve? And what Excel version are you on?
Nov 23 2021 02:33 AM
@Jc_Fadot hello, i used pivot table with filters for countries, level & domain, so when you filter for domain like agriculture you can know how many structures you have, hope this helps