Hello,
I have searched Excel Help and forums on here and I haven't been able to find an answer similar to what I require.
Is there a formula that I can use to transfer the employees dept (Column F) to Column H (dept)
Whereas I have used the Advanced Filter to transfer the unique Employee names to Column G, but I require the respective employee's department in Column H.
I believe a match formula may do, but I don't think they work with non-contiguous columns
Any ideas?
Thank you in advance!
I have searched Excel Help and forums on here and I haven't been able to find an answer similar to what I require.
Is there a formula that I can use to transfer the employees dept (Column F) to Column H (dept)
Whereas I have used the Advanced Filter to transfer the unique Employee names to Column G, but I require the respective employee's department in Column H.
I believe a match formula may do, but I don't think they work with non-contiguous columns
Any ideas?
Thank you in advance!
DRAFT FOR INTERNET - JULY 3.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
2 | Name | Report Date | TRC | Qty (Hrs) | DEPT | NAME | DEPT | OCCURENCES | ||
3 | EMPLOYEE1 | 15/05/2007 | SICK | 7.00 | SALES | EMPLOYEE1 | SALES | |||
4 | EMPLOYEE1 | 14/05/2007 | SICK | 3.50 | SALES | EMPLOYEE2 | MKTING | |||
5 | EMPLOYEE1 | 28/02/2007 | SICK | 7.00 | SALES | EMPLOYEE3 | HR | |||
6 | EMPLOYEE1 | 27/02/2007 | UNPEM | 7.00 | SALES | EMPLOYEE4 | ||||
7 | EMPLOYEE2 | 03/01/2007 | SICK | 7.00 | MKTING | EMPLOYEE5 | ||||
8 | EMPLOYEE3 | 22/03/2007 | SICK | 8.00 | HR | EMPLOYEE6 | ||||
9 | EMPLOYEE3 | 21/03/2007 | SICK | 8.00 | HR | |||||
10 | EMPLOYEE4 | 30/05/2007 | SICK | 8.00 | OPERATIONS | |||||
11 | EMPLOYEE4 | 29/05/2007 | SICK | 8.00 | OPERATIONS | |||||
12 | EMPLOYEE4 | 29/03/2007 | SICK | 8.00 | OPERATIONS | |||||
13 | EMPLOYEE4 | 10/03/2007 | SICK | 8.00 | OPERATIONS | |||||
14 | EMPLOYEE4 | 09/03/2007 | SICK | 8.00 | OPERATIONS | |||||
15 | EMPLOYEE4 | 13/02/2007 | SICKA | 4.00 | OPERATIONS | |||||
16 | EMPLOYEE4 | 17/01/2007 | SICK | 8.00 | OPERATIONS | |||||
17 | EMPLOYEE4 | 16/01/2007 | SICK | 8.00 | OPERATIONS | |||||
18 | EMPLOYEE4 | 15/01/2007 | SICK | 8.00 | OPERATIONS | |||||
19 | EMPLOYEE4 | 13/01/2007 | SICK | 2.83 | OPERATIONS | |||||
20 | EMPLOYEE5 | 19/04/2007 | SICK | 8.00 | ADMIN | |||||
21 | EMPLOYEE5 | 18/04/2007 | SICK | 8.00 | ADMIN | |||||
22 | EMPLOYEE5 | 17/04/2007 | SICK | 4.50 | ADMIN | |||||
23 | EMPLOYEE5 | 30/03/2007 | SICK | 8.00 | ADMIN | |||||
FULL QUERY DEPTS |