Sort by ending digits

J

JJ Mintz

My boss wants to sort by the last four digits of our ten-digit account
numbers. Does anybody know the steps to sort this way? A previous employee
created the sort and then recorded a macro for her to do this automatically.
 
C

Chip Pearson

Sort by ending digitsIn a column adjacent to your data, enter the
formula

=RIGHT(A1,4)

and copy down as far as you need to go. Then, sort on that
column.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




My boss wants to sort by the last four digits of our ten-digit
account numbers. Does anybody know the steps to sort this way? A
previous employee created the sort and then recorded a macro for
her to do this automatically.
 
A

Ardus Petus

Sort by ending digitsAssuming your account# is in A2 Create a staging column with formula = RIGHT(A2,4)
Then you can sort upont that temporary column

HTH
 
Top