I have item a list of products sold in a year. Each line represents one line in a sales order. There are multiple lines with the same Item number and an associated quantity. I want to create another set of columns with all unique Items and a total of all quantities listed for that Item. Thanks for your help!
Last edited by jaugent27; 05-31-2023 at 08:56 PM.
Try,
Please Login or Register to view this content.
E4:
F4:Please Login or Register to view this content.
Drag both downPlease Login or Register to view this content.
Quang PT
Try with Pivot Table
Attachment 831372
Wow, amazing josephteh! I put it in one cell and it just filled in all the others automatically. Great stuff!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks