Sachin has attended:
Excel Advanced course
Sort & Filter by Date
Hi
I am using a spreadsheet to prioritse my work by (1) numerical priority 1-3 and (2) by date the job was recieved.
How do I make a parameter so that it is sorted / filtered by these two automatically?
Currently I am using autofilter across the heading names - however, I need to keep filtering each time I add/remove/edit a line.
Please can I find another way of doing this- perhaps by using some of the advanced options or funtion builder. Alternatively, I cannot make the "sort" function understand that I want the oldest date first.
Kind Regards
Sachin Kotak
sachin.kotak@autotrader.co.uk
RE: Sort & Filter by Date
You can acheive this by extending your filter area further down the page. This means that when you add new lines, they will be included.
So, select the area with your data, including headings, and an additional 50 lines.
Then autofilter.
The other aspect would be for you to setup a VIEW.
Click View, then Custom views.
This allows you to set specific autofilter settings, and then save that view, to that you can get back to the setting you want very quickly.
Once you have setup the custom views, you could also add a toolbar using:
Right-click Toolbars, Customise, and looking under the Toolbars tab and dragging the CUSTOM VIEWS label and box to an existing toolbar. This iwill allow you to scroll through the various views you have saved, on demand.
The concept you are talking about is related to database type functionality. In Access you could have a saved query that always sorts your list, in the view you want, no matter how much you add. You can acheive this in Excel, as described above.
