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.