Forum Discussion
Andy-K1964
Aug 11, 2021Copper Contributor
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...
Yea_So
Aug 15, 2021Bronze Contributor
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