Ask Your Question
0

Sort referenced cells by cell value, not content

asked 2016-03-28 18:39:56 +0200

David gravatar image

updated 2016-03-28 18:54:08 +0200

I have some textual data in a Calc spreadsheet in Sheet1. It is referenced on another sheet.

Having re-ordered the data on Sheet1, the sort order on the other sheet now looks something like this:

=$Sheet1.A2
=$Sheet1.A3
=$Sheet1.A6
=$Sheet1.A1
=$Sheet1.A5
=$Sheet1.A4

When I try to use the Data > Sort options, it will only offer me an alphabetical sort of the content, NOT a sort on the cell numbers (A1, A2, A3, etc.).

Question: Is there a way to make Calc sort these cells on the value of the cell number, rather than an alpha sort of the referenced content? I live in hope!

I have looked at these Q&As without working out my question, so perhaps I'm missing something:

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-03-29 02:12:31 +0200

LKeithJordan gravatar image

Let's assume you currently have only one column on Sheet 2. My suggestion would be to add a column to Sheet 2 that allows you to specify the desired order for the cells in question -- then perform the sort for both columns on Sheet 2 based on the "Order" column.

Hope this helps.

Please click the check mark next to the response you believe best answers your question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2016-03-28 18:39:56 +0200

Seen: 105 times

Last updated: Mar 29 '16