Hello,

Pivot tables should be fine.

But if you like to do this with a macro or if you just want to know
how it could work:
Take my UDF Afreq from http://www.sulprobil.com/html/listfreq.html

Regards,
Bernd