| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I sort a list of numbers by the last 4 digits?
I have a list of numbers that are 6 digits long & I want to sort them
(ascending or descending) by the last 4 digits. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I sort a list of numbers by the last 4 digits?
Using a helper column, it is.
Assume number is in cell A2 - A1000, say.. in helper column, enter =Right(A2,4) Then sort based on the helper column... "Kristin S" wrote: I have a list of numbers that are 6 digits long & I want to sort them (ascending or descending) by the last 4 digits. Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I sort a list of numbers by the last 4 digits?
helper column
-- Don Guillett Microsoft MVP Excel SalesAid Software "Kristin S" <Kristin wrote in message ... I have a list of numbers that are 6 digits long & I want to sort them (ascending or descending) by the last 4 digits. Is this possible? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I sort a list of numbers by the last 4 digits?
Kristin,
One method is to insert a dummy column with formula =right(A1,4) Then use the sort function to sort the dummy column in ascending or descending order. Please advise if this works. Kristin S wrote: I have a list of numbers that are 6 digits long & I want to sort them (ascending or descending) by the last 4 digits. Is this possible? -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to sort a list of numbers by last two digit... | Excel Discussion (Misc queries) | |||
| sort by numbers of digits in cells | Excel Worksheet Functions | |||
| Making a list of numbers with 16 digits | Excel Worksheet Functions | |||
| How to sort out a list of numbers without duplication? | Excel Discussion (Misc queries) | |||
| How do I sort randomly a list of 22 numbers | Excel Discussion (Misc queries) | |||
Linear Mode
