|I hope someone can help with this, it's been about a year since I've worked with Excel and I cannot wrap my head around this!|
We're trying to track how long any company is in an employees queue but it's not continuous, the company can be sent to other employees for tasks so it might be gone a week before it comes back to the originating person.
A B C D
10/5/16 ABC Corp 000123456 Task A
10/5/16 XYZ Inc 888555999 Task A
10/5/16 123 Comp 554654545 Task A
10/6/16 XYZ Inc 888555999 Task B
10/7/16 ABC Corp 000123456 Task B
10/7/16 XYZ Inc 888555999 Task B
10/8/16 123 Comp 554654545 Task B
10/9/16 XYZ Inc 888555999 Task D
10/10/16 ABC Corp 000123456 Task B
10/10/16 123 Comp 554654545 Task C
10/12/16 123 Comp 554654545 Task D
This is what the list looks like when I get it, it's created by date so the companies can be anywhere.
I need to pull ABC Corp and see how long we had it. Task A, we received it so that's our start day. Task B, we send it out, so the end date. For ABC, that's a count of 2 days. Then there's another Task B, which means we got it back and sent it out the same day, so another 1 day so a count of 3 total.
XYZ has 1 day for Task A and B, then comes back for 1 day and goes straight to D (approval) so the count remains at 2 total.
123 has 3 days between Task A and B, then comes back to us for C where we have it for 2 days until it goes to Approval (D). Total count of 5 days.
Please tell me there is a shorter way to do this than counting! I was handed a spreadsheet with 538 rows of data (one employee out of 18!) and told this was a monthly task.