Hi all,

This is my problem. I have a table of data something like this:

31-1-2008 28-2-2008 31-3-2008
London
London
New York
Paris
London
New York
New York
Milan

I want to create a summary table with totals like this:

28-2-2008
London
Paris
New York
Milan

I want the totals to change when I change the date above to reflect the
correct month totals. The dates above are all formatted as dates.

Any ideas much appreciated as always.