Hello,
I would like to find out the best way to setup a sort or filter on the attached spreadsheet so that the 'Task' and associated 'Sub-Tasks' stay together when the other fields such as 'Status' are sorted please.
Hello,
I would like to find out the best way to setup a sort or filter on the attached spreadsheet so that the 'Task' and associated 'Sub-Tasks' stay together when the other fields such as 'Status' are sorted please.
simplest way is to add the property and task in every row so that data isnt missing. THis can easily be done by:
1) Select column A and B
2) Go to Home Ribbon and select "Find &Select" Then Select "Go to special..."
3) Select "Blanks" and then hit ok
4) press = then press the up button on your keyboard.
5) Now hit CTRL and Enter together and it should autofill all the blanks in columns A and B for you.
6) Finally select column A and B again. Copy them and paste them as values so the formulas are rmoved.
Now you should be able to sort and filter to your hearts content.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks