Excel VBA Dictionary Object, It's Great :)
Learn how to use the Dictionary object in VBA for Excel. They are great because you can add Objects and Arrays to dictionaries, making them so much more powerful than arrays! They also use the unique Key/Value pair system meaning no duplicates :)
To use the Dictionary for Mac please download Tim Halls code first and import to VBA:
https://github.com/VBA-tools/VBA-Dictionary
How to sort a Collection:
https://stackoverflow.com/questions/3587662/how-do-i-sort-a-collection
How to sort a Dictionary and more great details about the dictionary object:
https://excelmacromastery.com/vba-dictionary/