Ask Your Question
0

[calc] column alphabetically?

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

LibreGuy 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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 206 times

Last updated: Apr 21 '15