Ask Your Question

[calc] column alphabetically? [closed]

asked 2015-04-21 16:33:59 +0200

LibreGuy gravatar image

updated 2020-08-05 00:30:42 +0200

Alex Kemp gravatar image

Hi guys,

Since I already learned some cool tricks in Calc, I am wondering if it possible to automatically (on the fly) rearrange a column in alphabetical order.

Let's say I have a column containing these cells:

1 green
2 red

Is it possible that when I enter "blue" in the third cell, the column automatically rearranges itself in alphabetical order, so it will be:

1 blue
2 green
3 red

Can that be done?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-05 00:31:25.096113

1 Answer

Sort by » oldest newest most voted

answered 2015-04-21 21:10:24 +0200

pierre-yves samyn gravatar image

Hi - Without a macro, it is only possible with complex formulas in another column. Since it seems to me that you speak French I give you a link containing all the explanations (see 3 sheets in sample spreadsheet) of very intelligent formulas.

edit flag offensive delete link more


Thanks ... but I don't speak Fench :-/ So are you saying there's no easy solution for this one?

LibreGuy gravatar imageLibreGuy ( 2015-04-21 21:15:55 +0200 )edit

The pseudo misled me sorry. However, you can download the spreadsheet example and dissect the formulas.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-04-21 21:25:01 +0200 )edit

That looks complicated ... I think I'm better of just using the "sort" button then :)

LibreGuy gravatar imageLibreGuy ( 2015-04-21 21:29:44 +0200 )edit

Question Tools

1 follower


Asked: 2015-04-21 16:33:59 +0200

Seen: 246 times

Last updated: Apr 21 '15