[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
