how can I sort a column that consists of sizes (letters not number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a school volunteer trying to sort shirt sizes (youth and adult) YXS
through YXL and ADULT XS through ADULT XL. This is how they have been
entered on an Excel spreadsheet. How can I sort and total them by each class
group and then each size within each class? Help! Thanks!!!
 
Let's say you have:
column A: name of student/adult
column B: size
column C: class
I will further assume there are 100 entries
Not to worry, you will be able to work with my ideas even with different
setup.

First make sure that row 1 had labels (Name, Size, Class) You can easily
insert a row - right click the 1 row header and use insert row; now add
labels. So the first name is in A1 and the last in A101.

Second: Select everything and use Data Sort. The first sort is by class, the
second by size.

Third to get the counts (works even without sorting)

In F1, H1, G1 ..... enter the sizes
In E2, E3, E4... enter the class names
In F2 enter =SUMPROUDCT(--(B2:B101=F$1),--(C2:C101=$E2))
Adjust to match you actual ranges.
This will tell how many order there are for the first named class and the
first named size.
Copy along to cover all sizes and down to colver all rows.

I expect you know how to use AutoSum to insert =SUM(....) to get totals for
rows and columns

If your set up is very different or anything is unclear please come back.
I'll have an XXXL please
best wishes
 
Back
Top