If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 * |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|