| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to rearrange the information in a column. Help?
On Feb 26, 12:47*pm, lbrown wrote:
I need to sort the data in the column by the last few digits in the column and not the first few. Is this possible? You could use a helper column, in column B use this formula and copy it down =RIGHT(A2,3)*1 The select A1 and go to data=sort and sort by column B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to rearrange the information in a column. Help? | Excel Discussion (Misc queries) | |||
| Help, please - How to rearrange 1 column of data into 4 columns ? | Excel Discussion (Misc queries) | |||
| Consolidate information from Column B Based on Info In Column A | Excel Worksheet Functions | |||
| Rearrange numbers from a column in a different order in a second c | Excel Discussion (Misc queries) | |||
| increment a column based on information in another column | New Users to Excel | |||
Threaded Mode
