Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Say we have this data.

a   a   a
b   b   b
c   c   c
d   d   d
e   e   e

To produce this result:

a   e   a
b   d   b
c   c   c
d   b   d
e   a   e

...select column B, go to Data -> Sort and choose Current Selection. Then specify to sort Descending.

sort range

If, however, you want this result instead:

e   e   e
d   d   d
c   c   c
b   b   b
a   a   a

...then select all three columns, as described in @floris v's answer.