Andrew,

Thanks for the follow-up, I did use tech support's suggestion on the departmental comparative. I actually did see that it uses the =RNGMERGE()function, which was perfect.

Thanks guys!

Darcy Chretien