Ask Your Question
0

Is there a way to sort an array so that the order runs down a column then continues down the next column?

asked 2017-01-26 04:45:12 +0200

Freiherr gravatar image

updated 2017-01-26 08:12:15 +0200

Thus, if I had a field of data in columns and rows like this: Row 1 (10 8 5) Row 2 (7 6 4) Row 3 (3 2 1)

it would then sort (into descending order) into this: Row 1 (10 6 3) Row 2 (8 5 2) Row 3 (7 4 1)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-01-26 10:16:38 +0200

pierre-yves samyn gravatar image

Hi

You can use an array function (use the key combination Shift+Ctrl+Enter)

=LARGE($A$1:$C$3; {1.4.7;2.5.8;3.6.9})

Note: adapt the separators according to you ToolsOptionsCalcFormulaSeparators

See SortWithArray.ods

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-26 04:45:12 +0200

Seen: 148 times

Last updated: Jan 26 '17