Sounds like an application for a Pivot Table to me...

'Try here for some tips on them...' (
http://www.exceltip.com/excel_tips/E...Tables/32.html)


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=392300