Assuming you dont want to do this every day...
Sort the data by person and amount .. in a helper column use some
command like..
=if([name]<[name in cell above],"use","ignore")
Then add that column to the PAGE area and fiter out the "ignore"
values.
There must be a better way :-)
regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=528896