tru504187211
asked on
Excel - Sort multiple columns based on single column
Hi everyone,
Hopefully I can explain this correctly...
I am creating a spreadsheet to keep track of inventory. I would like to take the SKU #, model #, size, and style (wide, medium, etc.), which are already in a row...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
...and copy them into another worksheet on the same spreadsheet in a different format.
MODEL STYLE 12 13 14 15 16 17 18 19
26063 W 1 1
26063 M 1
...What this would do is allow there to be a quick way of seeing how many of each style there are per size. Each row is a different model (of course, each model has multiple styles, or widths, such as medium, wide, extra wide, etc.).
Is this possible???
Hopefully I can explain this correctly...
I am creating a spreadsheet to keep track of inventory. I would like to take the SKU #, model #, size, and style (wide, medium, etc.), which are already in a row...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
...and copy them into another worksheet on the same spreadsheet in a different format.
MODEL STYLE 12 13 14 15 16 17 18 19
26063 W 1 1
26063 M 1
...What this would do is allow there to be a quick way of seeing how many of each style there are per size. Each row is a different model (of course, each model has multiple styles, or widths, such as medium, wide, extra wide, etc.).
Is this possible???
You could also use COUNTIFS formula...
ASKER
Thanks for both of your replies...do you have a simple example of what you mean?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
AWESOME!....I think the last part then is getting the formula to have the single row of 26063 W, and the single row of 26063 M...from the rows below...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
I'm really scuffling with this part...
SKU MODEL SIZE STYLE
829024209851 26063 14 W
829024209852 26063 12 W
829024209853 26063 19 M
I'm really scuffling with this part...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
COUNTIFS worked best in my situation, but both solutions could work.
Model and Style will be in Row header, Size in column header and the Data could be Count of size.
Cheers,
Kris