How can I filter an Excel sheet based on a column's inactivity
Posted on 2016-08-02
I have an Excel spreadsheet with various columns. One of those is a column called "Comments." I would like to be able to filter rows based on the properties of the Comments.
I am looking to be able to filter the Comments based on a certain amount of days that it has been inactive, i.e. nothing has been written in it or deleted from it. If the number has to be fixed such as 7, then OK. I would rather be able to choose the number of days on different searches.