Have excel sheet sorted by bidder number. (col. J). want to pull out all bidder numbers that match, and add their $ (col. K) then put that total in Col. L. I'm rather new at this and can't figure out formula. Can someone help?
Thanks so much for your help. I ran the formula you posted, but it gave me an error. I am using Excel 2010 from Office package. I am going to post the file and see if that will help explain what I am trying to do.If you are running Excel 2007 take a look and see if this is what you need to do. This has macro code , so you will need to enable macros if you have macros disabled. Enter you some sample ID's and then click the Create Unique List button.
If you need 2003 .xls file let me know
Your instructions were kind of confusing (for me at least) based on how your sheet is layed out, so i took a guess at what you are looking to do. Changes can be made if this is close.