Remember Me?

#1
November 19th 06, 03:38 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 18
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
November 19th 06, 03:46 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 6,582
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
November 19th 06, 03:49 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 174
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
November 19th 06, 05:24 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 18
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
November 19th 06, 05:25 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 18
Sorting a column from the last letter or 2 letters of a part n

Thank you for your help. Great idea!

Brian Denny

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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jeffery Keown Excel Discussion (Misc queries) 5 October 17th 06 03:45 PM Justin Hoffmann Excel Worksheet Functions 2 July 12th 06 04:15 PM Neil Goldwasser Excel Worksheet Functions 4 May 30th 06 08:55 AM Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM

All times are GMT +1. The time now is 02:06 AM.