| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a column from the last letter or 2 letters of a part numbe
Anyone have any ideas on how to sort a column from the last letter or two
letters of a part number rather than the first. Sounds crazy, but it would save me hours of work monthly if I could figure this one out. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a column from the last letter or 2 letters of a part numbe
Use a helper column that uses a formula like =RIGHT(B2,2) to contain the
last two characters, and sort on this column. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Brian Denny" <Brian wrote in message ... Anyone have any ideas on how to sort a column from the last letter or two letters of a part number rather than the first. Sounds crazy, but it would save me hours of work monthly if I could figure this one out. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a column from the last letter or 2 letters of a part numbe
Try extracting the last letter or letters to another column, e.g. if your
data is in column A then use this formula in B1 to extract last two letters and copy down =RIGHT(A1,2) then sort both columns based on column B "Brian Denny" wrote: Anyone have any ideas on how to sort a column from the last letter or two letters of a part number rather than the first. Sounds crazy, but it would save me hours of work monthly if I could figure this one out. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a column from the last letter or 2 letters of a part n
Thanks Jon, I'll do that!
Brian Denny "Jon Peltier" wrote: Use a helper column that uses a formula like =RIGHT(B2,2) to contain the last two characters, and sort on this column. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Brian Denny" <Brian wrote in message ... Anyone have any ideas on how to sort a column from the last letter or two letters of a part number rather than the first. Sounds crazy, but it would save me hours of work monthly if I could figure this one out. Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting a column from the last letter or 2 letters of a part n
Thank you for your help. Great idea!
Brian Denny "daddylonglegs" wrote: Try extracting the last letter or letters to another column, e.g. if your data is in column A then use this formula in B1 to extract last two letters and copy down =RIGHT(A1,2) then sort both columns based on column B "Brian Denny" wrote: Anyone have any ideas on how to sort a column from the last letter or two letters of a part number rather than the first. Sounds crazy, but it would save me hours of work monthly if I could figure this one out. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
| Sorting Data From One Column into Multiple Columns | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
