Sorting in Excel

[Gregg]

I work with 12 digit loan numbers which are assigned to a specialist based on
the last 2 digits. I hope to find a way to sort on just the last two digits
so that loans are convieniently grouped by assigned specialist.

 

[Max]

Use a helper col, sort all by that helper
Eg, in E2, copied down: =RIGHT(A2,2)+0
Then sort all by col E

 

[FSt1]

hi,
you could use a helper column off to the right with with formula
assuming your loan number is in a1.
=right(A1,2)
this formual would pull the last 2 digits of the loan number into a seperate
column.
sort by helper column then loan number column (or other).

Regards
FSt1

 

[Dave]

Hi,
One way is to use a helper column.
If your 12-digit data is in Column A, starting Row 2, place this formula
into Row 2 of an available column and copy down.
=RIGHT(A2,2)
This puts the last 2 digits into each cell of the helper column.
Then you can sort by this column.
Regards - Dave.

 

[Gregg]

Thanks you all. Worked like a charm!