Forum Discussion
Site Count
I have 10,000 assets listed across 140 sites, each asset have varying frequency. I would like to count the number of sites that each asset type exists on based on there frequency and task type In th...
excel 2016 has other tools that you can use to solve the scenario:
https://www.microsoft.com/en-us/microsoft-365/blog/2015/09/10/integrating-power-query-technology-in-excel-2016/#:~:text=In%20Excel%202016%20we%20integrated%20the%20Power%20Query,Data%20tab%2C%20under%20the%20Get%20%26%20Transform%20section.
https://support.microsoft.com/en-us/office/create-a-data-model-in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b
https://support.microsoft.com/en-us/office/consolidate-data-in-multiple-worksheets-007ce8f4-2fae-4fea-9ee5-a0b2c9e36d9b