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?

How do I track recurring entries in Excel?
 

Yes. You would have to pick a consistent descriptor for the issue, in this
case, say "2nd Floor Bathroom Leak".

If each instance of bathroom leaks is a separate entry in your log, then you
could use the function =COUNTIF(A1:A100="2nd Floor Bathroom Leak"), assuming
the issue description is in the range A1:A100.

Depending on how you structure the workbook there are other ways to
accomplish the same task.

Dave
--
Brevity is the soul of wit.


"Felicia" wrote:

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?