sorting problem
One way is to create helper columns from the data. Assume
that the data is in column A then compute column for the
numerical sequence using.....
=VALUE(MID(A2,1,FIND("/",A2)-1))
then compute a column for the year using....
=RIGHT(A2,2)
then if you sort on the YEAR (descending) and the SEQUENCE
(descending) it will sort ok.
Cheers
Nigel
-----Original Message-----
Hello,
is it somehow possible to sort something like this:
37/05
39/05
147/03
44/05
48/05
264/04
42/05
41/05
43/05
45/05
41/04
47/05
251/04
258/04
46/05
42/05
The 2 digit to the right of the slash is the year
The digits to the left of the slash are consecutive
numbers, starting
with "1" for each year.
Can this be sorted, so that the last entry is on top and
the first
entry is at the bottom?
Thanks for any help
Regards,
Norbert
.
|