Sorting Problem

twoone

New Member
Joined
Apr 10, 2002
Messages
2
When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters.

HELP!
_________________
Larry
This message was edited by twoone on 2002-04-11 08:36
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
On 2002-04-11 08:35, twoone wrote:
When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters.

HELP!
_________________
Larry
This message was edited by twoone on 2002-04-11 08:36

what are the top three numbers? do you have field names?
 
Upvote 0
They are titled as below. This is "Item #" column that will not sort (top 3).
The "Shift" column is all "1"
SHIFT
1

ITEM #
411105
411172
411288
411010
411014
411034
411036
411038
411044
411045
 
Upvote 0
in another field, multiply the field by 1 and sort on that. I have hade this problem before and it was usually due to a "space" before or after the number.
 
Upvote 0
On 2002-04-11 08:46, twoone wrote:
They are titled as below. This is "Item #" column that will not sort (top 3).
The "Shift" column is all "1"
SHIFT
1

ITEM #
411105
411172
411288
411010
411014
411034
411036
411038
411044
411045

Could you do us this favour:

in a separate cell put = then
select an area that you have a problem with, so it say somthing like =A1:B40.

hit F9 and copy/paste the results here.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top