Ron,
Yes, this does help. Thank you again for the assistance.

GTT


Ron Coderre wrote:
For summaries, you might want to consider a Pivot Table.

First, make sure you have column headings on Sheet 2:
Examples: HighBid, BidderNum, BidderName

<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the BidderName field here
DATA: Drag the HighBid field here
If it doesn't list as Sum of HighBid...dbl-click it and set it to Sum
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each BidderName and the total of their winning bids.

To refresh the Pivot Table, just right-click it and select Refresh Data

For really good information on creating and using Pivot Tables, see Debra
Dalgleish's Contextures website:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

On a related matter, when one bidder wins multiple bids, is there an easier
method to summing up the total amount owed than sorting first by bidder
[quoted text clipped - 29 lines]
Thank you for any assistance in this problem.
GTT

--
Message posted via http://www.officekb.com