Link to home
Get AccessLog in
Avatar of tru504187211
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???
Avatar of leptonka
leptonka
Flag of Hungary image

I suggest to use Pivot table.
Model and Style will be in Row header, Size in column header and the Data could be Count of size.

Cheers,
Kris
You could also use COUNTIFS formula...
Avatar of tru504187211
tru504187211

ASKER

Thanks for both of your replies...do you have a simple example of what you mean?
ASKER CERTIFIED SOLUTION
Avatar of chwong67
chwong67
Flag of Malaysia image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
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...
SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
COUNTIFS worked best in my situation, but both solutions could work.