sorting data using numerical list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lyns - 07 Mar 2007 05:07 GMT

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

Reply to this Message

Max - 07 Mar 2007 06:13 GMT

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)

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi all,
>
[quoted text clipped - 3 lines]
>
> Any assistance would be greatly appreciated

Reply to this Message