Hello,
I have a problem with sorting. My sheet is set up so that colom 1 displays a general domain to which subdomains belong that are listed in colom 2. Like this:<table><tr><td valign=top>Infrastructure</Td><td>sub1
sub2
sub3</Td></tr><tr><td valign=top>Products</Td><td>sub1
sub2
sub3</Td></tr></Table>
if i however sort this data i get this:<table><tr><td valign=top>Infrastructure</Td><td>sub1</Td></tr><tr><td valign=top>Products</Td><td>sub2</Td></tr><tr><td valign=top></Td><td>sub3</Td></tr></Table>
Questions: How do i get excel to retain the blank cells in colom 1? And how do i prevent sub1 to sub3 to be consolidated (when using consolidate function), for the subdomain names are usually the same but belong to different domains.
Anyone gort an answer for this???
This message was edited by friso on 2002-04-02 00:24
This message was edited by friso on 2002-04-02 00:28
This message was edited by friso on 2002-04-02 00:30
I have a problem with sorting. My sheet is set up so that colom 1 displays a general domain to which subdomains belong that are listed in colom 2. Like this:<table><tr><td valign=top>Infrastructure</Td><td>sub1
sub2
sub3</Td></tr><tr><td valign=top>Products</Td><td>sub1
sub2
sub3</Td></tr></Table>
if i however sort this data i get this:<table><tr><td valign=top>Infrastructure</Td><td>sub1</Td></tr><tr><td valign=top>Products</Td><td>sub2</Td></tr><tr><td valign=top></Td><td>sub3</Td></tr></Table>
Questions: How do i get excel to retain the blank cells in colom 1? And how do i prevent sub1 to sub3 to be consolidated (when using consolidate function), for the subdomain names are usually the same but belong to different domains.
Anyone gort an answer for this???
This message was edited by friso on 2002-04-02 00:24
This message was edited by friso on 2002-04-02 00:28
This message was edited by friso on 2002-04-02 00:30