sorting data using numerical list

L

Lyns

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
 
M

Max

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)
 
Top