On 10/3/2011 4:29 PM, Dotan Cohen wrote:
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
What about making the 1st column discreet for each row and then making
the 2nd row of each record have the same content as for 1st row plus,
say, an "A" or something similar. This would make the second row of
each record follow the 1st row of the same record in a sort.
Using the previous example:
-------------------------------
1 | Some Info
-------------------------------
1A | More Info
-------------------------------
3 | Yet some more info
-------------------------------
3A | And more info
-------------------------------
2 | Some important info
-------------------------------
2A | More important info
-------------------------------
--
Dale Erwin
Lurigancho, Lima 15 PERU
http://leather.casaerwin.org
=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.26, Virus/Spyware Database: 6.18431)
http://www.pctools.com/
=======
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
