Tag Archives: Distinct Count

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 – particularly when dealing with mixed data types – … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , , , , , , , , , , , | 6 Comments

Count Distinct, Unique And Successive Values Using FREQUENCY()

Happy New Year, folks! And now, without further ado… In my opinion, one of the hardest worksheet functions to get the hang of is the FREQUENCY() function. For today’s post, I’ve assembled a collection of FREQUENCY() formulae which give a count of distinct, unique … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , | 16 Comments