If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel, sorting by least significant digit?

im invisible · 2011-05-08 14:44:53

is there a way of sorting colums of numbers (10+ digits) in excel by their least significant digits, (or by the four least significant digits, actually) say 52477596923 47845483875 75488548548 45375769595 would be sorted as 47845483875 52477596923 75488548548 45375769595 thanks,

08-05-2011 2:44pm

#1

im invisible

Closed Accounts Posts: 4,372 ✭✭✭

Join Date: February 2011

Posts: 4332

is there a way of sorting colums of numbers (10+ digits) in excel by their least significant digits, (or by the four least significant digits, actually) say

52477596923
47845483875
75488548548
45375769595

would be sorted as

47845483875
52477596923
75488548548
45375769595

thanks,

0

Comments

#2 08-05-2011 3:14pm

bhickey

Registered Users, Registered Users 2 Posts: 1,340 ✭✭✭

Join Date: May 2005

Posts: 1332

You could copy and then reverse the digits in another column and then sort by that new column? A quick google brings up :

B1=TRUNC(A1/10) + MOD(A1,10)*10

0
#3 08-05-2011 6:43pm

bonzodog2

Registered Users, Registered Users 2 Posts: 6,285 ✭✭✭

Join Date: October 2007

Posts: 6019

You could possibly split the number into 2 cells and combine them in a formula if you need the whole item.

0
#4 09-05-2011 3:53pm

Seamu$

Registered Users, Registered Users 2 Posts: 606 ✭✭✭

Join Date: April 2007

Posts: 581

Assuming your data is in Column A starting in A1 and Column B is available: Do a formula in B1 next to data and enter "=RIGHT(A1,4)". Then copy down the column. The formula is available in the fx paste function. Then highlight both columns and sort by Column B?

0