Specific sort order

[RobM]

I have data in several rows and columns ie:

95500 10
95501 10
R3550 40
S123 60
49996Y 40

I want to have this data sorted in a specific order, but not the way EXCEL
would like to sort it. My mainframe sorts by numbers first, then by letters
second, then by numbers mixed with letters third.

I can obtain a "Master sort list" to go by when I want to start, but how do
you force EXCEL to use this list (rather long list by the way)

 

[RobM]

Should have mentioned also that if there are lines missing in the sample data
to add rows so it matches the "Master sort list"

 

[Bill Ridgeway]

I have data in several rows and columns ie:

95500 10
95501 10
R3550 40
S123 60
49996Y 40

I want to have this data sorted in a specific order, but not the way EXCEL
would like to sort it. My mainframe sorts by numbers first, then by
letters
second, then by numbers mixed with letters third.

I can obtain a "Master sort list" to go by when I want to start, but how
do
you force EXCEL to use this list (rather long list by the way)

How do you want to see the output of your example above? (It would be
easier if we saw the actual, not assumed, requirement).

Bill Ridgeway

 

[RobM]

Hi Bill:

Sample of what I've got below:

59294X 59294X 28 0
59294Y 59294Y 6 0
59295X 59295X -7,728 0
59301X 59315X 196 0
59315X 59316X -92 0
59316X 59330AX 439 0
59330AX 59330BX 1 0
59330BX 59457X 487 0
59457X 59481X 4 0
59481X 59490X 10 0
59490X 59605X 170 0
59605X 59609Y 36 0
59609Y 59621X -8 0
59621X 59622X 411 0

The first column is the Master sort list, the next two columns are what I'm
trying to line up too by shifting these two colums down until the first
column matches the second column.

Rob

 

[Bill Ridgeway]

Rob,

I asked, specifically, "How do you want to see the output of your example
above?". Unfortunately there is a mismatch between the input data and the
output data in your latest example. If you could let me have input and
output data as separate tables I will try to help you. Apologies for being
pedantic but I (and others) have spent time finding an answer only to find
the Client hadn't asked the right question.

Regards.

Bill Ridgeway

 

[RobM]

Hi again Bill:

From what I have below, ignoring the first coulmn of data the other two
columns I want to line up to the first so that the result would look like
this:

59294X 59294X 280
59294Y 59294Y 60
59295X 59295X -7,728
59301X
59315X 59315X 196
59316X 59316X -92
59330AX 59330AX 439
59330BX 59330BX 1
59457X 59457X 487
59481X 59481X 4
59490X 59490X 10
59605X 59605X 170
59609Y 59609Y 36
59621X 59621X -8

The snipit below is from a vast list of data and the first and second colums
are what I'm trying to line up on one single row. The frist column (Part
numbers) will have every possible valid entry, the second and third column
will contain some data that I need to line up with the first column.

Rob