Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |