How To Get Unique Items In Excel Column | The Fastest Way In VBA
The fastest way to get unique items in an Excel column is to use a scripting dictionary. In this video, we look at how to loop through an Excel column and add unique values to the dictionary.
In this timed example, a column with 20,000 values took 0.07 seconds.