Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sort order Temporarily
I have a range A11:DZ298. Col B has a start time, Col C has an end tim and Col E has a alpha/numeric code that defines Start/End Combinations I am sorting By Col C, however if the value in E is "XJ8","C10",or"D10 I need to sort that group of rows only by column B. Then switch back t the regular sort on C again. Possible? Thanks :confused -- hotherp ----------------------------------------------------------------------- hotherps's Profile: http://www.excelforum.com/member.php...nfo&userid=505 View this thread: http://www.excelforum.com/showthread.php?threadid=31435 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Sort order Temporarily
I think you'll need to do this with a macro. Presumably the data must also be
sorted by column E also, or does the sort on column C get the column E data into the correct order? On Wed, 17 Nov 2004 08:31:52 -0600, hotherps wrote: I have a range A11:DZ298. Col B has a start time, Col C has an end time and Col E has a alpha/numeric code that defines Start/End Combinations. I am sorting By Col C, however if the value in E is "XJ8","C10",or"D10" I need to sort that group of rows only by column B. Then switch back to the regular sort on C again. Possible? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the sort order of the filter | Excel Discussion (Misc queries) | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
How to change the column order in Excel table with multiple sort | Excel Discussion (Misc queries) | |||
Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) | |||
how can i change the default sort order in excel? | Excel Programming |