Collections & Dictionary
Group, count and de-duplicate thousands of rows in one pass using keys instead of nested loops.
The first lesson is free — no account needed.
About this course
Group, count and de-duplicate thousands of rows in one pass using keys instead of nested loops. You learn the Collection object, Scripting.Dictionary, early versus late binding, counting and grouping rows, de-duplicating and matching lists, and storing more than a number per key in a VBA Dictionary.