Aidan,
Thanks for your reply. I haven't used pivot tables before so I will check
the help file.
Cheers, Martin.

" wrote:

You can use an array formula, BUT you might like to look at Pivot
Tables first as these could possibly give you a quicker solution