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.

Use a helper col, sort all by that helper
Eg, in E2, copied down: =RIGHT(A2,2)+0
Then sort all by col E
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gregg" wrote:
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.

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

"Gregg" wrote:

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.

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.

Thanks you all. Worked like a charm!

"Gregg" wrote:

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.