Tag Archives: Frequency

FREQUENCY() Post Updated

I’ve updated an old post on counting distinct, unique and successive values using the FREQUENCY() function. I was participating on a thread over at Chandoo.org when an answer from Haseeb Avarakkan made me realise that my formula could be improved from: … Continue reading

Posted in Microsoft Excel | Tagged , , | Leave a comment

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

Conditional Average On Non-Contiguous Ranges Using FREQUENCY()

At the beginning of the year I talked about the FREQUENCY() worksheet function and gave a handful of examples on how it can be used. Today’s article is another, brilliant FREQUENCY() example which was posted by Barry Houdini on the MrExcel board. I’ve … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , , | 8 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