You're very welcome. The Pivot table is probably the single most powerful
feature that excel has (Yet can be so simple to use), and is certainly worth
getting to grips with.

Regards
Ken..................

"crosswire123"
wrote in message
news:crosswire123.25jutb_1143834602.9458@excelforu m-nospam.com...

Thank you.It worked beautifully.
im surprised they didn't teach us this at Univ lol
thanks once again


--
crosswire123
------------------------------------------------------------------------
crosswire123's Profile:
http://www.excelforum.com/member.php...o&userid=33051
View this thread: http://www.excelforum.com/showthread...hreadid=528665