ordering a table

[merlin777]

This seems quite simple to me but i'm a bit rusty and i just cant figure it out.

I have a table full of orders (which gets added to) with

order number/garment type/design type/fabric colour/printing colour/size

eg:

10000001/tshirt/frog/green/black/XL

i want to order them, starting with the most popular items, by colour and design, so ignoring size and order number

Cant get my head round how to total up each combination and then order them. Hopefully not pivot tables as im not too good with those! VBA and macros would probably be okay though....

 

[marshy3300]

Hi Merlin,

You state by colour and design. Which colour (fabric or print?)
Also the most popular items would imply you have some kind of numerical value assigned somewhere. Where does that sit? Is it how many times 10000001 is ordered or a quantity sitting somewhere which is green/frog?

 

[merlin777]

Hi marshy. It's the combination of design, fabric color and print colour (so the potential number of combos is huge although only a fraction of them would be practical).
And there is no quantity column, the order number will be repeated for multiple items.

I have to say I'm doing this for a friend who already has his table and a lot of data already entered so although I wouldn't do it like this I'm trying to work with it to save him reentering it.