Thanks for your kind words (and I don't even have XL2007!!).

Pete

On Jul 1, 9:20*pm, Rookie_User
wrote:
Your awesome!! Yes I did use the advanced filter to get the unique dates -
this didn't happen in my pre 2007 version of Excel I don't think. *I will try
what you suggested but great diagnosing. :)