Ask Your Question
0

Sort referenced cells by cell value, not content [closed]

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

David gravatar image

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

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-02 14:29:14.876695

1 Answer

Sort by » oldest newest most voted
0

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

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

Question Tools

2 followers

Stats

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

Seen: 171 times

Last updated: Mar 29 '16