thanks for the reply. i need to do this in a pivot table. cant use the $
referencing structure in calculated fields unfortunately...


--
fax
------------------------------------------------------------------------
fax's Profile: http://www.excelforum.com/member.php...o&userid=28912
View this thread: http://www.excelforum.com/showthread...hreadid=486922