| 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 |
| 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 | |||
Threaded Mode
