Can you create an intermediate column which joins the two together, eg
insert after B, and use a formula like =A1&"/"&B1 (which will give a
result like "Ref/Address")

Then use Column C as your subtotal group (and hide cols A and B).

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=564031