Hi,
I am a beginner in Excel and would require the following help :-)
I have copied incidents and problem records in a blank worksheet.
1. I need to compare the worksheet with a previous worksheet with the same headers.
2. If a new item has been added, the record will be marked as green/blue.
3. Items that are no more in our queue should be marked as yellow.
4. A column should be automatically added and SLA calculation to be done automatically. The SLA is
When docket is critical= SLA is 4 hours (24x7)
When docket is high=SLA is 10 hours (24x7)
When docket is medium and low= 10 hours ( 8 AM-6PM : Mon-Fri only)
5. Taking cue from 4, a column "SLA Breached" should be automatically created and it should automatically show "yes" for breached and "No" for not breached and mark yes ones with red.
PLEASE SOMEBODY HELP ME WITH A SOLUTION.
Thanks in advance.
Bookmarks