Thread: sorting problem
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default 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
.