Sorting Rows and Levels
 

Can anyone help me with this problem. I am looking to sort warehouse
locations by level and row. The locations are as follows: 210064C. The
breakdown on this is the 21 is the row, the 006 is the column, the 4 is the
level and the letter is the placement of merchandise in that location. Below
I have added sample locations that I would like to set by row and level.
Thanks in Advance, Mac

210222A
210222B
210222C
210223A
210223B
210223C
210224A
210224B
210224C
210225B
210225C
210245B
220031A
220031B
220031C
220031C
220031C
220032B
220032C
220033B
220034A
220035A
220035B
220035C

Sorting Rows and Levels
 

Try this

Col A u have data ,
in col B put this formula =right(A1,1) and drag it till u have the
data
in col C put this formula =left(A1,2) and drag it till u have the data

and then go to data | sort | sort by : col B , then by : col C | ok





On Sep 23, 1:21*pm, Mac wrote:
Can anyone help me with this problem. *I am looking to sort warehouse
locations by level and row. *The locations are as follows: *210064C. *The
breakdown on this is the 21 is the row, the 006 is the column, the 4 is the
level and the letter is the placement of merchandise in that location. *Below
I have added sample locations that I would like to set by row and level. * *
Thanks in Advance, *Mac

210222A *
210222B *
210222C *
210223A *
210223B *
210223C *
210224A *
210224B *
210224C *
210225B *
210225C *
210245B *
220031A *
220031B *
220031C *
220031C *
220031C *
220032B *
220032C *
220033B *
220034A *
220035A *
220035B *
220035C *

Sorting Rows and Levels
 

Muddan, Can not get first formula to work. Seems it will not capture a
letter.

Thanks

Mac

"muddan madhu" wrote:

Try this

Col A u have data ,
in col B put this formula =right(A1,1) and drag it till u have the
data
in col C put this formula =left(A1,2) and drag it till u have the data

and then go to data | sort | sort by : col B , then by : col C | ok





On Sep 23, 1:21 pm, Mac wrote:
Can anyone help me with this problem. I am looking to sort warehouse
locations by level and row. The locations are as follows: 210064C. The
breakdown on this is the 21 is the row, the 006 is the column, the 4 is the
level and the letter is the placement of merchandise in that location. Below
I have added sample locations that I would like to set by row and level.
Thanks in Advance, Mac

210222A
210222B
210222C
210223A
210223B
210223C
210224A
210224B
210224C
210225B
210225C
210245B
220031A
220031B
220031C
220031C
220031C
220032B
220032C
220033B
220034A
220035A
220035B
220035C

Sorting Rows and Levels
 

Muddan,

I got it to work. Thanks
a lot.

Mac

"muddan madhu" wrote:

Try this

Col A u have data ,
in col B put this formula =right(A1,1) and drag it till u have the
data
in col C put this formula =left(A1,2) and drag it till u have the data

and then go to data | sort | sort by : col B , then by : col C | ok





On Sep 23, 1:21 pm, Mac wrote:
Can anyone help me with this problem. I am looking to sort warehouse
locations by level and row. The locations are as follows: 210064C. The
breakdown on this is the 21 is the row, the 006 is the column, the 4 is the
level and the letter is the placement of merchandise in that location. Below
I have added sample locations that I would like to set by row and level.
Thanks in Advance, Mac

210222A
210222B
210222C
210223A
210223B
210223C
210224A
210224B
210224C
210225B
210225C
210245B
220031A
220031B
220031C
220031C
220031C
220032B
220032C
220033B
220034A
220035A
220035B
220035C

Sorting Rows and Levels
 

In 2 helper columns

=LEFT(A2,2) =MID(A2,6,1)

Sort on those.


Gord Dibben MS Excel MVP

On Tue, 23 Sep 2008 10:21:01 -0700, Mac
wrote:

Can anyone help me with this problem. I am looking to sort warehouse
locations by level and row. The locations are as follows: 210064C. The
breakdown on this is the 21 is the row, the 006 is the column, the 4 is the
level and the letter is the placement of merchandise in that location. Below
I have added sample locations that I would like to set by row and level.
Thanks in Advance, Mac

210222A
210222B
210222C
210223A
210223B
210223C
210224A
210224B
210224C
210225B
210225C
210245B
220031A
220031B
220031C
220031C
220031C
220032B
220032C
220033B
220034A
220035A
220035B
220035C