invert a sequence column in a dataset

[chrisgo]

I would want to invert a sequence/order column in a dataset given a max sequence order:

example:

max sequence order=4

col1          seq

A               1

B                2

C               3

D               4

E               2

F               1

change to:

col1          seq

A               4

B               3

C               2

D               1

E               3

F               4

Thanks,

[Howles · Accepted solution]

how about

   seq = 5 - seq ;

[chrisgo]

thanks