Check out this article to get the files and scripts used in this demo - https://powerusers.microsoft.com/t5/P...
For more information about Office Scripts checkout: https://docs.microsoft.com/office/dev...
Content
0:00 Introduction
2:26 Start scripting - return unique events
14:17 2nd Script - format missing data
50:42 Create Power Automate flow to run both scripts
On this page of the site you can watch the video online Excel Office Scripts: Cross reference Multiple Excel Files with a duration of hours minute second in good quality, which was uploaded by the user Sudhi Ramamurthy 25 October 2020, share the link with friends and acquaintances, this video has already been watched 13,006 times on youtube and it was liked by 130 viewers. Enjoy your viewing!