troubleshooting Question

How can I filter an Excel sheet based on a column's inactivity

Avatar of Bert2005
Bert2005Flag for United States of America asked on
Microsoft Excel
29 Comments5 Solutions114 ViewsLast Modified:
HI experts,

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.

Thanks.
ASKER CERTIFIED SOLUTION
Tom Farrar
Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 5 Answers and 29 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 5 Answers and 29 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros