How do I track recurring entries in Excel?

F

Felicia

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?
 
D

Dave F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Copy previous record into form field 0
How do I clear a form? 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
How do I create a set of words that are flagged? 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Recurring Date 2
How do I create recurring entries in Excel? 1

Top