K Kristin S May 18, 2009 #1 I am using Excel 2003. Can I sort a list of numbers by the last four digits? There are apprximately 6 digits in each number.
I am using Excel 2003. Can I sort a list of numbers by the last four digits? There are apprximately 6 digits in each number.
E Elkar May 18, 2009 #2 The easiest way would be to create a helper column and perform your sort using that. Let's assume your original data is in column A and your new helper column is column B. In column B enter the formula: =RIGHT(A1,4) Copy down as needed. Then, when you sort, use Column B. HTH Elkar
The easiest way would be to create a helper column and perform your sort using that. Let's assume your original data is in column A and your new helper column is column B. In column B enter the formula: =RIGHT(A1,4) Copy down as needed. Then, when you sort, use Column B. HTH Elkar
E Elkar May 18, 2009 #3 The easiest way would be to create a helper column and perform your sort using that. Let's assume your original data is in column A and your new helper column is column B. In column B enter the formula: =RIGHT(A1,4) Copy down as needed. Then, when you sort, use Column B. HTH Elkar
The easiest way would be to create a helper column and perform your sort using that. Let's assume your original data is in column A and your new helper column is column B. In column B enter the formula: =RIGHT(A1,4) Copy down as needed. Then, when you sort, use Column B. HTH Elkar
