C
Cesar Urquidi
Hello,
I have a large worksheet with data (columns "a", "b" & "c"). (I'm using only
a few records for reference).
Here are the columns:
Order # Employee Hrs.
1000 Mike 2
2000 Mike 1
1000 Paul 2
3000 Rose 3
8000 Mike 1
3000 Mike 2
1000 Rose 1
4000 Paul 1
7000 John 3
5000 Rose 2
1000 John 3
6000 Mike 1
9000 Mike 3
1000 Mike 2
I filtered the data of column "a" (Order #) and reflected it on column "d",
and sorted in ascending order.
Then, I filtered the data of column "b" (Employee) and reflected it on
column "e", and sorted in ascending order.
Now I have only one of each of the "Order #" and the "Employee".
And last, I just typed "Hrs." in column "f".
After all this, the data looks like this:
Order # Employee Hrs. Order # Employee Hrs.
1000 Mike 2 1000 John
2000 Mike 1 2000 Mike
1000 Paul 2 3000 Paul
3000 Rose 3 4000 Rose
8000 Mike 1 5000
3000 Mike 2 6000
1000 Rose 1 7000
4000 Paul 1 8000
7000 John 3 9000
5000 Rose 2
1000 John 3
6000 Mike 1
9000 Mike 3
1000 Mike 2
John, Mike, Paul & Rose will be working on different orders, and I need to
know how many hrs. they work on each order every week so I can put them on a
chart.
Is there a formula I can enter in column "f" (Hrs.), so I can obtain the
total hours each employee works per order?
Please note that if an employee worked on the same "Order #" on two or more
different dates, that needs to be added up, otherwise the chart is going to
have multiple bars for the same employee in that "Order #".
Help please!!!
Thank you,
Cesar Urquidi
I have a large worksheet with data (columns "a", "b" & "c"). (I'm using only
a few records for reference).
Here are the columns:
Order # Employee Hrs.
1000 Mike 2
2000 Mike 1
1000 Paul 2
3000 Rose 3
8000 Mike 1
3000 Mike 2
1000 Rose 1
4000 Paul 1
7000 John 3
5000 Rose 2
1000 John 3
6000 Mike 1
9000 Mike 3
1000 Mike 2
I filtered the data of column "a" (Order #) and reflected it on column "d",
and sorted in ascending order.
Then, I filtered the data of column "b" (Employee) and reflected it on
column "e", and sorted in ascending order.
Now I have only one of each of the "Order #" and the "Employee".
And last, I just typed "Hrs." in column "f".
After all this, the data looks like this:
Order # Employee Hrs. Order # Employee Hrs.
1000 Mike 2 1000 John
2000 Mike 1 2000 Mike
1000 Paul 2 3000 Paul
3000 Rose 3 4000 Rose
8000 Mike 1 5000
3000 Mike 2 6000
1000 Rose 1 7000
4000 Paul 1 8000
7000 John 3 9000
5000 Rose 2
1000 John 3
6000 Mike 1
9000 Mike 3
1000 Mike 2
John, Mike, Paul & Rose will be working on different orders, and I need to
know how many hrs. they work on each order every week so I can put them on a
chart.
Is there a formula I can enter in column "f" (Hrs.), so I can obtain the
total hours each employee works per order?
Please note that if an employee worked on the same "Order #" on two or more
different dates, that needs to be added up, otherwise the chart is going to
have multiple bars for the same employee in that "Order #".
Help please!!!
Thank you,
Cesar Urquidi