Could you not use a pivot table, but rather than using the sum function
in the data part of the pivot table for the book value use Max instead


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=527094