How do I track recurring entries in Excel?
I'm creating a database in excel for maintenance issues in our building. I'm
listing the date, Location, Issue, Person assigned to resolve the Issue,
Status and Date Issue Resolved. Some issues reoccur and I would like to be
able to track when I input entries like this. If we continually get a leak
in the 2nd floor Bathroom, I would like to be flagged. Can I do this with
Excel 2003?
|