Hello forum folks. Long time reader first time poster.
I am trying to collate some data for my company and i am really struggling, so have come here in the hopes that you can help. I'm sure it can be done but our IT department are really struggling staff-wise and have deemed this not urgent for the business, but it is extremely urgent in my job role.
Here's my Dilemma
For each of our orders we have various departments that each have a set time for processing.
Dept Process days
14 1
16 4
19 2
20 2
50 1
60 1
70 1
93 1
98 2
Different orders can go through any combination of departments. So when displayed in excel would show as
Job# Dept
1 14
1 16
1 93
2 20
2 50
2 70
2 98
3 14
3 93
4 60
4 70
4 98
What i need to display are jobs that only have dept 93 in their process and also display a total time for each order. So that the returned data looks like this.
Job# Total Time
1 6
3 2
Like i say i am really struggling to do it. We use Excel 2003 and i'm guessing perhaps a macro of some sort would do the trick, but i have no idea how to do it. Can anyone help?
Bookmarks