Hi Barb -

I didn't see this question at first, but I responded in the original thread. I
didn't try to replicate the OP's one column setup from his first post, because it
didn't match the more logical arrangement in his post in the other forum.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:

Jon,

How would you do this with a Pivot Table? I'm not a Pivot Table novice and
I just can't envision how this one would be done.

Thanks,
Barb