I am trying to do something like a frequency chart or table but haven't been able to figure it out.
I have a list of orders shipped out and the boxes that were used to package them. For example, Order 1 might be put in a 202 size box. Order 2 might need a 202 size box and a 216 size box. Order 3 could need 2 of the 202 size boxes. Order 4 might need 2 of the 202 size boxes and one of the 216 size.
There are 13 sizes all together.
I am trying to find the top 10 combinations. For example, 30 of the orders used one 216 size box. 25 orders used one 216 and one 202 size box. 20 orders used two 202 size boxes and one 216 size box.
I have only seen formulas that return results where items/numbers are not duplicated within a row.
Any suggestions are greatly appreciated!
Bookmarks