Hello. I' trying to find a way to filter several Places in one sheet
What I want to havethe options to filter/sort tasks in a logical order or dates. That is bothtask 1,2,3,4,5 and ascending dates to task 1,2,3,4,5. See the illustrationunderneath.
The problem is thatthe tasks and dates are organized and grouped under different people. I need asolution to organize only all the entries under Mike, Tim or Ann. I could of course use different sheets, however this is not a feasable solution here.
Any input?
Thanks
Mike
1 Task Date
2 Task Date
3 Task Date
4 Task Date
5 Task Date
Ann
1 Task Date
2 Task Date
3 Task Date
4 Task Date
5 Task Date
Tom
1 Task Date
2 Task Date
3 Task Date
4 Task Date
5 Task Date
What I want to havethe options to filter/sort tasks in a logical order or dates. That is bothtask 1,2,3,4,5 and ascending dates to task 1,2,3,4,5. See the illustrationunderneath.
The problem is thatthe tasks and dates are organized and grouped under different people. I need asolution to organize only all the entries under Mike, Tim or Ann. I could of course use different sheets, however this is not a feasable solution here.
Any input?
Thanks
Mike
1 Task Date
2 Task Date
3 Task Date
4 Task Date
5 Task Date
Ann
1 Task Date
2 Task Date
3 Task Date
4 Task Date
5 Task Date
Tom
1 Task Date
2 Task Date
3 Task Date
4 Task Date
5 Task Date