10 - Count duplicates (Power Query/Pivot table/VBA)
Using Power Query/Pivot tables/VBA to show only the duplicates in a list, including counting how often they occur.
I'm doing a terrible job of advocating for VBA...
00:00 - Intro
00:16 - Power Query
00:56 - Pivot table (no Datamodel)
01:51 - Pivot table (Datamodel)
02:46 - VBA
06:25 - Adding a shortcut to the ribbon
06:51 - Adding a shortcut key
No clue how to use tags
#excel, #pivot_table, #powerquery, #vba
Watch video 10 - Count duplicates (Power Query/Pivot table/VBA) online without registration, duration hours minute second in high quality. This video was added by user WesleySon 10 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 149 once and liked it 1 people.