managed to find a way using subtotals, not a formula like i was after,
but it does the job


--
andymaw11
------------------------------------------------------------------------
andymaw11's Profile: http://www.excelforum.com/member.php...o&userid=35931
View this thread: http://www.excelforum.com/showthread...hreadid=557243