Thanks very much. I agree the layout isn't the best but it's because I will be using pivot tables so I'm limited as to what I can do to the layout. That said, Marcol, you r formula does the trick. Thanks very much.

Arlu1201, I haven't tried yours yet but will do this afternoon out of interest.

Thanks to you both for your answers.

Dean