| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula (Not Macro) For Sorting By Row
I have an excel spreadsheet with part numbers in Column A and bin
locations in Cols. B to G. I would like to find a formula that sorts the bin locations in Cols. B-G alphabetically. The bin locations are formatted as Text. For instance, Cols B1 to G1 show: 22-2D 49-6A 48-1A 49-1C 49-5A I would like to have a formula in Cols. H1 to O1 that sorts like this: 22-2D 48-1A 49-1C 49-5A 49-6A Can anybody help me? Thanks. -- tb |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula (Not Macro) For Sorting By Row
I have an excel spreadsheet with part numbers in Column A and bin
locations in Cols. B to G. I would like to find a formula that sorts the bin locations in Cols. B-G alphabetically. The bin locations are formatted as Text. For instance, Cols B1 to G1 show: 22-2D 49-6A 48-1A 49-1C 49-5A I would like to have a formula in Cols. H1 to O1 that sorts like this: 22-2D 48-1A 49-1C 49-5A 49-6A Can anybody help me? Thanks. Why not use Excel's built-in Sort feature on the row[s]? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula (Not Macro) For Sorting By Row
On 12/12/2017 at 11:05:12 PM GS wrote:
I have an excel spreadsheet with part numbers in Column A and bin locations in Cols. B to G. I would like to find a formula that sorts the bin locations in Cols. B-G alphabetically. The bin locations are formatted as Text. For instance, Cols B1 to G1 show: 22-2D 49-6A 48-1A 49-1C 49-5A I would like to have a formula in Cols. H1 to O1 that sorts like this: 22-2D 48-1A 49-1C 49-5A 49-6A Can anybody help me? Thanks. Why not use Excel's built-in Sort feature on the row[s]? Because (I think) I would have to sort each row individually. That would take forever. Each row has bin numbers for a different part number, so I would have to sort Row 1 by itself, then sort Row 2 by itself, etc. etc. Am I perhaps missing something? -- tb |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula (Not Macro) For Sorting By Row
On 12/12/2017 at 11:05:12 PM GS wrote:
I have an excel spreadsheet with part numbers in Column A and bin locations in Cols. B to G. I would like to find a formula that sorts the bin locations in Cols. B-G alphabetically. The bin locations are formatted as Text. For instance, Cols B1 to G1 show: 22-2D 49-6A 48-1A 49-1C 49-5A I would like to have a formula in Cols. H1 to O1 that sorts like this: 22-2D 48-1A 49-1C 49-5A 49-6A Can anybody help me? Thanks. Why not use Excel's built-in Sort feature on the row[s]? Because (I think) I would have to sort each row individually. That would take forever. Each row has bin numbers for a different part number, so I would have to sort Row 1 by itself, then sort Row 2 by itself, etc. etc. Am I perhaps missing something? In the Sort dialog Options/Orientation, choose Left to Right! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula (Not Macro) For Sorting By Row
On 12/13/2017 at 2:49:34 PM GS wrote:
On 12/12/2017 at 11:05:12 PM GS wrote: I have an excel spreadsheet with part numbers in Column A and bin locations in Cols. B to G. I would like to find a formula that sorts the bin locations in Cols. B-G alphabetically. The bin locations are formatted as Text. For instance, Cols B1 to G1 show: 22-2D 49-6A 48-1A 49-1C 49-5A I would like to have a formula in Cols. H1 to O1 that sorts like this: 22-2D 48-1A 49-1C 49-5A 49-6A Can anybody help me? Thanks. Why not use Excel's built-in Sort feature on the row[s]? Because (I think) I would have to sort each row individually. That would take forever. Each row has bin numbers for a different part number, so I would have to sort Row 1 by itself, then sort Row 2 by itself, etc. etc. Am I perhaps missing something? In the Sort dialog Options/Orientation, choose Left to Right! Right but then you have to tell Excel with one of the rows is the primary sorting key. All the other rows will be sorted based on the primary sorting key. I need to sort each row _independently_ from any other row. Say I have the following bin locations in Row 1 and Row 2 (each row represents bin locations for a different part number): 22-2D 49-6A 48-1A 49-1C 49-5A 30-1B 05-2C 25-4D 01-1A 11-5B When I do a Custom Sort - Options - Sort left to right, I have to specify a Sort By Row key. Let's assume that I pick Row 1 as my Sort By Row key. The end result would be this: 22-2D 48-1A 49-1C 49-5A 49-6A 30-1B 25-4D 01-1A 11-5B 05-2C As you can see, Row 1 was sorted correctly but Row 2 was not. -- tb |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula (Not Macro) For Sorting By Row
On 12/13/2017 at 2:49:34 PM GS wrote:
On 12/12/2017 at 11:05:12 PM GS wrote: I have an excel spreadsheet with part numbers in Column A and bin locations in Cols. B to G. I would like to find a formula that sorts the bin locations in Cols. B-G alphabetically. The bin locations are formatted as Text. For instance, Cols B1 to G1 show: 22-2D 49-6A 48-1A 49-1C 49-5A I would like to have a formula in Cols. H1 to O1 that sorts like this: 22-2D 48-1A 49-1C 49-5A 49-6A Can anybody help me? Thanks. Why not use Excel's built-in Sort feature on the row[s]? Because (I think) I would have to sort each row individually. That would take forever. Each row has bin numbers for a different part number, so I would have to sort Row 1 by itself, then sort Row 2 by itself, etc. etc. Am I perhaps missing something? In the Sort dialog Options/Orientation, choose Left to Right! Right but then you have to tell Excel with one of the rows is the primary sorting key. All the other rows will be sorted based on the primary sorting key. I need to sort each row _independently_ from any other row. Say I have the following bin locations in Row 1 and Row 2 (each row represents bin locations for a different part number): 22-2D 49-6A 48-1A 49-1C 49-5A 30-1B 05-2C 25-4D 01-1A 11-5B When I do a Custom Sort - Options - Sort left to right, I have to specify a Sort By Row key. Let's assume that I pick Row 1 as my Sort By Row key. The end result would be this: 22-2D 48-1A 49-1C 49-5A 49-6A 30-1B 25-4D 01-1A 11-5B 05-2C As you can see, Row 1 was sorted correctly but Row 2 was not. Can you use a macro? -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and coloring cells, formula or macro help needed | Excel Discussion (Misc queries) | |||
| Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
| Sorting with a macro or a formula | Excel Discussion (Misc queries) | |||
| help with sorting data in excel(Macro) | Excel Programming | |||
| Please Help with Excel Sorting Macro!! | Excel Programming | |||
Hybrid Mode
