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?

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?