sorting data using numerical list
 

Hi all,

i have a real proble I need to sort a large data base of files using the
client file number. Problem is I need to list all file ending in 0,1,2 etc.
is there away to list the files numerically using the last digit?

Any assistance would be greatly appreciated

sorting data using numerical list
 

Sort the table using a helper col as the sort key
Eg assuming filenumbers in A1 down, place in an adjacent col to the right of
the table, say in X1: =RIGHT(A1)+0
Copy X1 down, then sort the entire table by col X ascending (say)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lyns" wrote:
Hi all,

i have a real proble I need to sort a large data base of files using the
client file number. Problem is I need to list all file ending in 0,1,2 etc.
is there away to list the files numerically using the last digit?

Any assistance would be greatly appreciated