I'm looking to find a way to custom sort when each item consists of two lines but I need to sort by date. In the example that i've attached, I need it to show task 2, 1, 3 in that order by start date. How can I sort it to also keep the end date right below it. Keep in mind this is not the acutal data and it has to stay in this format.
Thanks.Book1.xlsx
You need to duplicate the task ID in each row to keep the tasks together. Or you could put the end date in a separate column and use a single row per task.
Entia non sunt multiplicanda sine necessitate
Book1(1).xlsx
that's what i thoought too but it didn't work. see attached
Which column do you need to sort on first if you want to keep the tasks together?
As far as I can see selecting the range A3:D8 and on the "Home" tab selecting "Sort & Filter" and using "Sort smallest to largest" gives you the result you wanted (tested with excel 2007 and 2010)
Alf
I need the start and end date to stay together. So both rows for task 1, both rows for task 2, both rows for task 3. Rather, it sorts just the dates leaving them all discombobulated. The biggest issue is that the start date is fluid, so as the start date of the task changes i need a quick and easy way to sort hundreds of lines but they have to stay in rows of 2.
You're sorting by the date column and then the task column. Reverse that.
I'm sorry, I'm not trying to be stupid here. If i sort by task, it puts it numerically, If i sort by date first, it makes it all discombobulated. In the example that I attached, I need rows 3&4 to sort by 10/23. I need rows 5&6 to sort by 10/17. I need rows 7&8 to sort by 10/26.
Like this?
Row\Col
EDIT: Or you want it like this?
Row\Col
If that's the case, then put the end date in a separate column and sort by start date:
Row\Col
Last edited by shg; 10-20-2015 at 12:54 PM.
yes, that's what i'm starting with, but now looking at the start dates of 10/23 (task 1), 10/17 (task 2) and 10/26 (task 3), i would need it to be able to sort task 2,1,3
Then you need to arrange the records in database fashion, one row per task, as shown in the last example.
Like i said, i need them to remain in two rows for their function of feeding a chart on another tab. when i do it your way i loose % complete on the other tab.
I'm skeptical of the design that requires that, but you could duplicate the start date in another column and sort by that:
Row\Col
It's not the cleanest and i'm sure my formatting isn't right on the other chart page, but in the end i can hid column e and this works.
Thanks for your help. I appreciate it.
I'll ask one more question if you are still out there... Can i set up a function (like print area) for sorting so that it is already set up for the end user. All they will have to do is click a button, or is this to far out there?
Sure. Try recording a macro and then it can be cleaned up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks