Tag Archives: Charles Williams

FastExcel V3 Released

Microsoft MVP and Excel calculation guru Charles Williams has finally released an updated version of FastExcel. It’s a fantastic product which I highly recommend and there’s a 50% discount introductory offer available until 31st July 2014 if you use the coupon code … Continue reading

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