Would you rather not use a pivot table for this type of task? This will
group all items (no duplicates) with grand totals etc..


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=565847