colinlegg.wordpress.com
Count Distinct Or Unique Values – VBA UDF
A handful of posts ago I looked at some FREQUENCY() formulae which could give a count of distinct or unique values in a given column. The formulae became quite complicated and slow – particul…