Sort by ending digits

[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.

 

[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.

 

[Nick Hodge]

Sort by ending digitsJust use a helper column, so say the acc. nos are in column A then in the helper column enter

=RIGHT(A2,4)

and copy down

You can then sort on the helper column

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)


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.

 

[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

 

[CLR]

Sort by ending digitsFor special sorting jobs, especially ones that I have to do frequently, I use Jim Cone's fine commercial add-in called "Special Sort", available at http://www.realezsites.com/bus/primitivesoftware/products.php and reviewed at http://www.officeletter.com/blink/specialsort.html

Vaya con Dios,
Chuck, CABGx3


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.