| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting out rows | Excel Worksheet Functions | |||
| Sorting rows into a row | Excel Discussion (Misc queries) | |||
| Sorting Rows | Excel Discussion (Misc queries) | |||
| Sorting rows | Excel Worksheet Functions | |||
| sorting rows | Excel Worksheet Functions | |||
Linear Mode
