sample3.xlsx
I'm still having issues with this workbook. I cannot use a pivot table to fix it, I don't understand them and it confuses me greatly..... so I'm at the mercy of either a formula or macro. I need to combine the duplicate part numbers (a), total the quantities, average the price (d), and total the amount of the part (e). I'm having a very difficult time with it. Can anyone help educate me?
Thank you!
(I have a sample attached that is file sample 2, and the entire spreadsheet attached- sample 3)
Bookmarks