I have a sales sheet that notes the customers order number and then every product linked to that particular order number, which in turn falls within a specific product group. The problems is, the report details everything individually (line by line) so If I have an order with 6 items, the order number appears 6 times detailing each individual sku/product group. In the second sheet I removed all duplicate order numbers and then tried to use various functions to input each each product group linked to an order - my goal was to count the number of different product groups for each order - please help - I cant seem to find a function that works. Is this an impossible task!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Help!!
- Thread starter Jbenso
- Start date
AlphaFrog
MrExcel MVP
- Joined
- Sep 2, 2009
- Messages
- 16,489
It sounds like you could use a Pivot Table. They are not hard to make, but I wouldn't say it's intuitive. There are several tutorials online. Search for something line Excel Pivot Tables, and you'll find many. Here's one...
Create a Pivot Table in Excel
Upvote
0
