Re: Calc: Sort double columns

[A duplicate may appear -- I sent one from the wrong e-mail.]

<orcmid note="comments below" />

-----Original Message-----
From: Dotan Cohen [mailto:[email protected]] 
Sent: Monday, October 03, 2011 14:30
To: [email protected]
Cc: [email protected]
Subject: [users] Re: Calc: Sort double columns

On Mon, Oct 3, 2011 at 20:08, Dennis E. Hamilton
<[email protected]> wrote:
>  I think it can all be handled.  First, eliminate the merged cell
>  that has the number in it.  Just have the top of the two have the
>  number and make the border between the empty cell underneath invisible.
>
>  Secondly, make a column that has the actual sorting sequence in it.
>  To match the intended number, use something like 1.0, 1.1, etc.
>  (It should be possible to use some formula magic to populate this
>  row-key column with values derived from the cells that actually
>  have the visible numbers.
>
>  Use the row-key column to sort the entries into the proper sequence.
>  The column can be made invisible and it should still be usable in sorting.
>
>  Note: If there are other keys that are to be sorted by, and they only
>  appear in one row or another, these need to be expanded into (hidden)
>  keys on each row so they work too.  There are ways to do this so sorting
>  by different keys that still keeps the grouping of the paired rows
>  together.

Thanks, I will try that idea. Maybe if the key is in column A then I
could sort on a column with a value like this (psuedocode):
floor( columnA/2 ) *2

<orcmid>
  Because every other row has no entry in column A, I would do something
  like this, assuming the keys are in column B.  Let the first row be 5
  (to allow for heading cells, etc.).  (Use whatever your first row of
  the details is.)

  For B5, set =A5
  For B6, set =IF(ISBLANK(A6),B5+0.1,A6)

  Then fill down the rest of column B with the formula in X6.

  Even if you hide column B (but remember to extend it if you add
  more paired rows to the table), you should be able to sort by
  it.
</orcmid>

-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help

-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help