B
blakelysmercantile
I am having a problem with the sort function after entering a custom list,
and sorting by that list, the sort does not follow my pattern, or the order
of my entries. I have searched previous problems listed in the Discussion
Groups and haven't found my specific problem, however, just a warning, I am
not quite as computer literate as others, so if I give too much info or not
enough, as I don't know how much you need, please forgive. =)
I am using the worksheet to inventory children's clothes. After begining at
Home, I've gone to the Sort & Filter > Custom Sort > Sort by (D): Size, Sort
on: Values, Order: (this is a custom list I previously entered). I must add
that I have over 500 total worksheet entries presently. Approximately a
month ago, I lost this information and had to start from the beginning.
Prior to losing my info, I had sorted in the same way, and that sort DID
follow my value pattern, nevertheless, I had only approximately 100-175
entries at that time. Here is an example of my custom value list and the
order in which I want the info sorted:
0-3m, 0-3-6m, 0-6m, 0-9m, 3m, 3-6m, 6m, 6-9m, 6-12m, 6-12-18m, 9m, 9-12m,
12m, 12-18m, 18m, 18-24m, 24m, 36m, 2T, 2T-3T, 3T, 3, 3/4, 4T, 4/4T, 4, 4-5T,
5T, 6, 7, 8, 10, 12, 01M, 02M, 03M, 04M, 5M, 6M, 7M, 8M, 9M, 10M, 11M, 12M,
2M, 3M, OS, 0-12m, 6-18m, 12-24m, 3-12m, 2-3Y, 4-5Y, 6-7Y, small, medium
This is the order in which the sizes were sorted, also the order shown in
the drop down now that the sort has been performed (as best as I can tell, as
I cannot see every value in the drop down box):
Visible top row in drop down box:
3m*, 3-6m, 6m*, 6-12m, 9m*, 9-12m, 12m*, 18m, 18-24m, 24m...
Visible bottom row in drop down box:
2T, 3T, 2T-5T, 12-24m, 6-18m, 0-12m, OS, 3M, 2M, 12M, 11M, 10M, 9M, 8M...
Post sort order on worksheet, Column D, begins exactly as the Visible top
row in drop down box, EXCEPT where I have indicated by #m*, there is an
interuption by the same number but with the capitol M, (m=month, M=Medium),
sofor example, in the middle of 3 month clothes, I have four pairs of size
3Medium shoes, and this is not acceptable.
After the 24m... from the order in the Visible top row, there is order, but
it is not continuous order, e.g.:
2T, 3T, 3, 4T, 5T, 5, 6, 7, ...12, 01M, 02M, 03M, ...11M, 2M, 12-18m, 13M,
2-3Y, 24m, 2T-3T, 2T-4T, 1,(obviously this is an error on my part in the
"number" format, as I never had a "1"), 3-12m, 3-4Y, 36m, 3T-4T, 4-5Y...
I would like to know what I need to do so my values will sort in the desired
custom order that I previously wrote (and obviously will have to write again).
I apologize if this is excessive information. I appreciate your time and
consideration in this matter, and look forward to your response!
Best Regards,
and sorting by that list, the sort does not follow my pattern, or the order
of my entries. I have searched previous problems listed in the Discussion
Groups and haven't found my specific problem, however, just a warning, I am
not quite as computer literate as others, so if I give too much info or not
enough, as I don't know how much you need, please forgive. =)
I am using the worksheet to inventory children's clothes. After begining at
Home, I've gone to the Sort & Filter > Custom Sort > Sort by (D): Size, Sort
on: Values, Order: (this is a custom list I previously entered). I must add
that I have over 500 total worksheet entries presently. Approximately a
month ago, I lost this information and had to start from the beginning.
Prior to losing my info, I had sorted in the same way, and that sort DID
follow my value pattern, nevertheless, I had only approximately 100-175
entries at that time. Here is an example of my custom value list and the
order in which I want the info sorted:
0-3m, 0-3-6m, 0-6m, 0-9m, 3m, 3-6m, 6m, 6-9m, 6-12m, 6-12-18m, 9m, 9-12m,
12m, 12-18m, 18m, 18-24m, 24m, 36m, 2T, 2T-3T, 3T, 3, 3/4, 4T, 4/4T, 4, 4-5T,
5T, 6, 7, 8, 10, 12, 01M, 02M, 03M, 04M, 5M, 6M, 7M, 8M, 9M, 10M, 11M, 12M,
2M, 3M, OS, 0-12m, 6-18m, 12-24m, 3-12m, 2-3Y, 4-5Y, 6-7Y, small, medium
This is the order in which the sizes were sorted, also the order shown in
the drop down now that the sort has been performed (as best as I can tell, as
I cannot see every value in the drop down box):
Visible top row in drop down box:
3m*, 3-6m, 6m*, 6-12m, 9m*, 9-12m, 12m*, 18m, 18-24m, 24m...
Visible bottom row in drop down box:
2T, 3T, 2T-5T, 12-24m, 6-18m, 0-12m, OS, 3M, 2M, 12M, 11M, 10M, 9M, 8M...
Post sort order on worksheet, Column D, begins exactly as the Visible top
row in drop down box, EXCEPT where I have indicated by #m*, there is an
interuption by the same number but with the capitol M, (m=month, M=Medium),
sofor example, in the middle of 3 month clothes, I have four pairs of size
3Medium shoes, and this is not acceptable.
After the 24m... from the order in the Visible top row, there is order, but
it is not continuous order, e.g.:
2T, 3T, 3, 4T, 5T, 5, 6, 7, ...12, 01M, 02M, 03M, ...11M, 2M, 12-18m, 13M,
2-3Y, 24m, 2T-3T, 2T-4T, 1,(obviously this is an error on my part in the
"number" format, as I never had a "1"), 3-12m, 3-4Y, 36m, 3T-4T, 4-5Y...
I would like to know what I need to do so my values will sort in the desired
custom order that I previously wrote (and obviously will have to write again).
I apologize if this is excessive information. I appreciate your time and
consideration in this matter, and look forward to your response!
Best Regards,