jackfox68
Board Regular
- Joined
- Jan 24, 2010
- Messages
- 121
I have an activity report I use to determine the time an employee logs into the phones system, and what time they puts themselves into a status that makes them available to receive calls. Currently this is a manual process. I would like to automate this process using excel, if at all possible. I need excel to show me the first time an employee meets the following combined criteria:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Logged in = 1
Status Key = Available
(For example: dgamboa would return the value in cell B9 because the “Logged in(Flag)” value equals “1” and the “Status key” value equals “Available”<o></o>
I have a list of user ids I can copy and paste into another sheet in excel. I would like the results to be shown next to the corresponding user id<o></o>
Any help, ideas, suggestions would be appreciated<o></o>
Excel 2010
Logged in = 1
Status Key = Available
(For example: dgamboa would return the value in cell B9 because the “Logged in(Flag)” value equals “1” and the “Status key” value equals “Available”<o></o>
I have a list of user ids I can copy and paste into another sheet in excel. I would like the results to be shown next to the corresponding user id<o></o>
Any help, ideas, suggestions would be appreciated<o></o>
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | User id | State Start (Date/time) | LoggedIn (Flag) | Status key | ||
2 | aaraya | 11/8/2011 03:25:45 PM | 1 | Gone Home | ||
3 | aaraya | 11/8/2011 03:25:45 PM | 1 | Gone Home | ||
4 | aaraya | 11/8/2011 04:23:25 PM | 1 | Available | ||
5 | aaraya | 11/8/2011 04:54:08 PM | 1 | Follow Up | ||
6 | aaraya | 11/8/2011 04:54:38 PM | 1 | Available | ||
7 | dgamboa | 11/8/2011 02:05:00 PM | 1 | Gone Home | ||
8 | dgamboa | 11/8/2011 02:05:00 PM | 1 | Gone Home | ||
9 | dgamboa | 11/8/2011 02:05:04 PM | 1 | Available | ||
10 | dgamboa | 11/8/2011 03:13:32 PM | 1 | Follow Up | ||
11 | dgamboa | 11/8/2011 03:14:32 PM | 1 | Available | ||
12 | dgamboa | 11/8/2011 04:14:33 PM | 1 | Follow Up | ||
13 | jlandero | 11/8/2011 02:23:50 PM | 1 | Gone Home | ||
14 | jlandero | 11/8/2011 02:23:50 PM | 1 | Gone Home | ||
15 | jlandero | 11/8/2011 02:30:25 PM | 1 | Available | ||
16 | jlandero | 11/8/2011 02:50:03 PM | 1 | Follow Up | ||
17 | jlandero | 11/8/2011 02:51:03 PM | 1 | Available | ||
18 | jlandero | 11/8/2011 03:34:20 PM | 1 | Follow Up | ||
19 | jlandero | 11/8/2011 03:35:20 PM | 1 | Available | ||
20 | jlandero | 11/8/2011 03:43:57 PM | 1 | Follow Up | ||
Sheet2 |