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 |