Tough Data Sheet to get Login/Login dates and times.

[pitcrew]

Hello, I have a difficult Spreadsheet I am working with to try and get the data I need. I am trying to get sign-in (S/In) and Sign-out (S/Out) times for my employees from phone system report.
The problem is the report shows each employee's sign-in and sign-out for the entire week. Also, these events show multiple times (as when they login it logs them into several different phone ques all at once). So I need to find a way to pull out the first sign-in for each employee each day. then I need to pull the last sign-out for each employee each day.

Here is the mini sheet of the data, smaller version of course.

Pitcrew Login -Logout Report.xlsx
	A	B	C
1	Entry Time	Agent Name	State Chg
2	9/11/2023 9:01	Jennifer Leibenguth	S/In
3	9/11/2023 9:01	Jennifer Leibenguth	N/A
4	9/11/2023 9:01	Jennifer Leibenguth	S/In
5	9/11/2023 9:01	Jennifer Leibenguth	S/In
6	9/11/2023 9:01	Jennifer Leibenguth	S/In
7	9/11/2023 9:01	Jennifer Leibenguth	S/In
8	9/11/2023 9:01	Jennifer Leibenguth	S/In
9	9/11/2023 9:01	Jennifer Leibenguth	S/In
10	9/11/2023 9:01	Jennifer Leibenguth	Avail
11	9/11/2023 9:01	Jennifer Leibenguth	Alrt(Call)/A
12	9/11/2023 9:01	Jennifer Leibenguth	Busy(Call)/A
13	9/11/2023 9:05	Bonnie Bleier	Busy(Call)/A
14	9/11/2023 9:11	Jennifer Leibenguth	Avail
15	9/11/2023 9:11	Jennifer Leibenguth	W/U
16	9/11/2023 9:11	Jennifer Leibenguth	Avail
17	9/11/2023 9:13	Bonnie Bleier	Avail
18	9/11/2023 9:14	Bonnie Bleier	Avail
19	9/11/2023 9:14	Jennifer Leibenguth	Alrt(Call)/A
20	9/11/2023 9:15	Jennifer Leibenguth	Busy(Call)/A
21	9/11/2023 9:18	Jennifer Leibenguth	Avail
22	9/11/2023 9:29	Lori Dement	S/In
23	9/11/2023 9:29	Lori Dement	N/A
24	9/11/2023 9:29	Lori Dement	S/In
25	9/11/2023 9:29	Lori Dement	S/In
26	9/11/2023 9:29	Lori Dement	S/In
27	9/11/2023 9:29	Lori Dement	S/In
28	9/11/2023 9:29	Lori Dement	S/In
29	9/11/2023 9:52	Bonnie Bleier	Avail
30	9/11/2023 9:53	David Powers	S/In
31	9/11/2023 9:53	David Powers	N/A
32	9/11/2023 9:53	David Powers	S/In
33	9/11/2023 9:53	David Powers	S/In
34	9/11/2023 9:53	David Powers	S/In
35	9/11/2023 9:53	David Powers	S/In
36	9/11/2023 9:53	David Powers	S/In
37	9/11/2023 9:54	Jennifer Leibenguth	N/A
38	9/11/2023 9:57	Bonnie Bleier	Alrt(Call)/A
39	9/11/2023 9:57	Bonnie Bleier	Busy(Call)/A
40	9/11/2023 9:57	Jennifer Leibenguth	Avail
41	9/11/2023 10:00	Bonnie Bleier	Avail
42	9/11/2023 10:00	Bonnie Bleier	W/U
43	9/11/2023 11:37	David Powers	Alrt(Call)/A
44	9/11/2023 11:37	Lori Dement	N/A
45	9/11/2023 11:37	David Powers	Busy(Call)/A
46	9/11/2023 11:45	David Powers	Avail
47	9/11/2023 11:45	David Powers	W/U
48	9/11/2023 11:55	Bonnie Bleier	W/U
49	9/11/2023 11:55	Bonnie Bleier	Avail
50	9/11/2023 15:00	Marianne Peterson	S/Out
51	9/11/2023 15:00	Marianne Peterson	S/Out
52	9/11/2023 15:00	Marianne Peterson	S/Out
53	9/11/2023 15:00	Marianne Peterson	S/Out
54	9/11/2023 15:00	Marianne Peterson	S/Out
55	9/11/2023 15:00	Marianne Peterson	S/Out
56	9/11/2023 15:00	Marianne Peterson	S/Out
57	9/11/2023 15:05	David Powers	N/A
58	9/11/2023 15:06	David Powers	Avail
59	9/11/2023 15:12	Bonnie Bleier	Avail
60	9/11/2023 15:12	Bonnie Bleier	W/U
61	9/11/2023 15:12	Bonnie Bleier	Avail
62	9/11/2023 15:14	Bonnie Bleier	Alrt(Call)/A
63	9/11/2023 15:14	Bonnie Bleier	Busy(Call)/A
64	9/11/2023 15:15	Jennifer Leibenguth	Avail
65	9/11/2023 15:15	Jennifer Leibenguth	W/U
66	9/11/2023 15:15	David Powers	Avail
67	9/11/2023 15:15	David Powers	W/U
68	9/11/2023 15:15	Jennifer Leibenguth	Avail
69	9/11/2023 15:15	David Powers	Avail
70	9/11/2023 15:17	Jennifer Leibenguth	N/A
71	9/11/2023 15:19	Bonnie Bleier	Avail
72	9/11/2023 15:20	Bonnie Bleier	Alrt(Call)/A
73	9/11/2023 15:21	Bonnie Bleier	Busy(Call)/A
74	9/11/2023 15:21	Jennifer Leibenguth	Avail
75	9/11/2023 15:21	Bonnie Bleier	Avail
76	9/11/2023 15:32	Jennifer Leibenguth	N/A
77	9/11/2023 15:32	Lori Dement	Alrt(Call)/A
78	9/11/2023 15:32	Lori Dement	Busy(Call)/A
79	9/11/2023 15:37	Lori Dement	Avail
80	9/11/2023 15:37	Lori Dement	W/U
81	9/11/2023 15:38	Lori Dement	Avail
82	9/11/2023 15:46	Bonnie Bleier	W/U
83	9/11/2023 15:46	Bonnie Bleier	Avail
84	9/11/2023 15:48	Lori Dement	Avail
85	9/11/2023 15:48	Lori Dement	W/U
86	9/11/2023 15:48	Lori Dement	Avail
87	9/11/2023 15:51	Bonnie Bleier	Alrt(Call)/A
88	9/11/2023 15:51	Bonnie Bleier	Busy(Call)/A
89	9/11/2023 15:57	Lori Dement	N/A
90	9/11/2023 15:59	Bonnie Bleier	N/A
91	9/11/2023 16:01	Bonnie Bleier	S/Out
92	9/11/2023 16:01	Bonnie Bleier	S/Out
93	9/11/2023 16:01	Bonnie Bleier	S/Out
94	9/11/2023 16:01	Bonnie Bleier	S/Out
95	9/11/2023 16:01	Bonnie Bleier	S/Out
96	9/11/2023 16:01	Bonnie Bleier	S/Out
97	9/11/2023 16:03	David Powers	Avail
98	9/11/2023 16:07	David Powers	Alrt(Call)/A
99	9/11/2023 16:07	David Powers	Busy(Call)/A
100	9/11/2023 16:10	Jennifer Leibenguth	Avail
101	9/11/2023 16:13	David Powers	Avail
102	9/11/2023 16:13	David Powers	W/U
103	9/11/2023 16:13	David Powers	Avail
104	9/11/2023 16:17	Jennifer Leibenguth	Alrt(Call)/A
105	9/11/2023 16:17	Jennifer Leibenguth	Busy(Call)/A
106	9/11/2023 16:20	David Powers	Alrt(Call)/A
107	9/11/2023 16:20	David Powers	Busy(Call)/A
108	9/11/2023 16:23	Jennifer Leibenguth	Avail
109	9/11/2023 16:23	Jennifer Leibenguth	W/U
110	9/11/2023 16:23	Jennifer Leibenguth	Avail
111	9/11/2023 16:33	Jennifer Leibenguth	Alrt(Call)/A
112	9/11/2023 16:33	Jennifer Leibenguth	Busy(Call)/A
113	9/11/2023 16:34	David Powers	Avail
114	9/11/2023 16:34	David Powers	W/U
115	9/11/2023 16:34	David Powers	Avail
116	9/11/2023 16:36	David Powers	Alrt(Call)/A
117	9/11/2023 16:36	Jennifer Leibenguth	Avail
118	9/11/2023 16:36	Jennifer Leibenguth	W/U
119	9/11/2023 16:36	David Powers	Busy(Call)/A
120	9/11/2023 16:37	Jennifer Leibenguth	Avail
121	9/11/2023 16:42	David Powers	Avail
122	9/11/2023 16:42	David Powers	W/U
123	9/11/2023 16:42	David Powers	Avail
124	9/11/2023 16:46	Lori Dement	Avail
125	9/11/2023 16:52	Lori Dement	Alrt(Call)/A
126	9/11/2023 16:52	Lori Dement	Busy(Call)/A
127	9/11/2023 16:52	David Powers	N/A
128	9/11/2023 16:53	Jennifer Leibenguth	Alrt(Call)/A
129	9/11/2023 16:53	Jennifer Leibenguth	Busy(Call)/A
130	9/11/2023 16:57	David Powers	S/Out
131	9/11/2023 16:57	David Powers	S/Out
132	9/11/2023 16:57	David Powers	S/Out
133	9/11/2023 16:57	David Powers	S/Out
134	9/11/2023 16:57	David Powers	S/Out
135	9/11/2023 16:57	David Powers	S/Out
136	9/11/2023 16:57	Jennifer Leibenguth	Avail
137	9/11/2023 16:57	Jennifer Leibenguth	W/U
138	9/11/2023 17:00	Jennifer Leibenguth	Alrt(Call)/A
139	9/11/2023 17:00	Jennifer Leibenguth	Busy(Call)/A
140	9/11/2023 17:00	Lori Dement	Avail
141	9/11/2023 17:00	Lori Dement	W/U
142	9/11/2023 17:01	Lori Dement	Avail
143	9/11/2023 17:04	Lori Dement	Alrt(Call)/A
144	9/11/2023 17:04	Lori Dement	Busy(Call)/A
145	9/11/2023 17:05	Lori Dement	Avail
146	9/11/2023 17:05	Lori Dement	W/U
147	9/11/2023 17:05	Lori Dement	Avail
148	9/11/2023 17:06	Jennifer Leibenguth	Avail
149	9/11/2023 17:06	Jennifer Leibenguth	W/U
150	9/11/2023 17:24	Lori Dement	Avail
151	9/11/2023 17:25	Lori Dement	Alrt(Call)/A
152	9/11/2023 17:25	Lori Dement	Busy(Call)/A
153	9/11/2023 17:29	Jennifer Leibenguth	S/Out
154	9/11/2023 17:29	Jennifer Leibenguth	S/Out
155	9/11/2023 17:29	Jennifer Leibenguth	S/Out
156	9/11/2023 17:29	Jennifer Leibenguth	S/Out
157	9/11/2023 17:43	Lori Dement	Avail
158	9/11/2023 17:43	Lori Dement	Alrt(Call)/A
159	9/11/2023 17:43	Lori Dement	Busy(Call)/A
160	9/11/2023 17:47	Lori Dement	N/A
161	9/11/2023 17:50	David Powers	S/In
162	9/11/2023 17:50	David Powers	N/A
163	9/11/2023 17:50	David Powers	S/In
164	9/11/2023 17:50	David Powers	S/In
165	9/11/2023 17:51	David Powers	Avail
166	9/11/2023 17:51	David Powers	Alrt(Call)/A
167	9/11/2023 17:51	David Powers	Busy(Call)/A
168	9/11/2023 17:51	Lori Dement	S/Out
169	9/11/2023 17:51	Lori Dement	S/Out
170	9/11/2023 17:51	Lori Dement	S/Out
171	9/12/2023 9:01	Bonnie Bleier	S/In
172	9/12/2023 9:01	Bonnie Bleier	S/In
173	9/12/2023 9:01	Bonnie Bleier	S/In
174	9/12/2023 9:24	David Powers	S/In
175	9/12/2023 9:24	David Powers	N/A
176	9/12/2023 9:24	David Powers	S/In
177	9/12/2023 9:24	David Powers	S/In
178	9/12/2023 9:27	Jennifer Leibenguth	S/In
179	9/12/2023 9:27	Jennifer Leibenguth	N/A
180	9/12/2023 9:27	Jennifer Leibenguth	S/In
181	9/12/2023 9:49	Lori Dement	Busy(Call)/A
182	9/12/2023 9:50	David Powers	Alrt(Call)/A
183	9/12/2023 9:50	David Powers	Busy(Call)/A
184	9/12/2023 9:52	Bonnie Bleier	S/Out
185	9/12/2023 9:52	Bonnie Bleier	S/Out
186	9/12/2023 9:52	Bonnie Bleier	S/Out
187	9/12/2023 9:52	Bonnie Bleier	S/Out
188	9/12/2023 9:52	David Powers	Avail
189	9/12/2023 9:52	David Powers	W/U
190	9/12/2023 9:52	David Powers	Avail
191	9/12/2023 9:53	David Powers	Alrt(Call)/A
192	9/12/2023 9:53	David Powers	Busy(Call)/A
193	9/12/2023 9:53	David Powers	Avail
194	9/12/2023 9:54	Lori Dement	Avail
195	9/12/2023 9:58	David Powers	Alrt(Call)/A
196	9/12/2023 9:58	David Powers	Busy(Call)/A
197	9/12/2023 9:59	David Powers	Avail
198	9/12/2023 9:59	David Powers	W/U
199	9/12/2023 9:59	Lori Dement	Alrt(Call)/A
200	9/12/2023 9:59	Lori Dement	Busy(Call)/A
201	9/12/2023 9:59	David Powers	Avail
202	9/12/2023 9:59	David Powers	Alrt(Call)/A
203	9/12/2023 9:59	David Powers	Busy(Call)/A
204	9/12/2023 10:37	Lori Dement	Avail
205	9/12/2023 10:37	Lori Dement	Alrt(Call)/A
206	9/12/2023 10:37	Lori Dement	Busy(Call)/A
207	9/12/2023 10:41	Bonnie Bleier	S/In
208	9/12/2023 10:41	Bonnie Bleier	S/In
209	9/12/2023 10:41	Bonnie Bleier	Alrt(Call)/A
210	9/12/2023 10:41	Bonnie Bleier	Busy(Call)/A
211	9/12/2023 10:43	Lori Dement	Avail
212	9/12/2023 10:43	Lori Dement	W/U
213	9/12/2023 10:43	Lori Dement	Avail
214	9/12/2023 10:45	Lori Dement	Alrt(Call)/A
215	9/12/2023 10:45	Lori Dement	Busy(Call)/A
216	9/12/2023 10:45	Bonnie Bleier	Avail
217	9/12/2023 10:45	Bonnie Bleier	W/U
218	9/12/2023 10:45	Bonnie Bleier	Avail
219	9/12/2023 10:51	Lori Dement	Avail
220	9/12/2023 10:51	Lori Dement	W/U
221	9/12/2023 10:51	Lori Dement	Avail
222	9/12/2023 10:52	Lori Dement	Alrt(Call)/A
223	9/12/2023 10:52	Lori Dement	Busy(Call)/A
224	9/12/2023 10:54	Bonnie Bleier	Alrt(Call)/A
225	9/12/2023 11:00	Bonnie Bleier	Busy(Call)/A
226	9/12/2023 11:03	Lori Dement	N/A
227	9/12/2023 11:10	Bonnie Bleier	Avail
228	9/12/2023 11:10	Bonnie Bleier	W/U
229	9/12/2023 11:10	Bonnie Bleier	Avail
230	9/12/2023 11:51	David Powers	Avail
231	9/12/2023 11:51	David Powers	W/U
232	9/12/2023 11:51	David Powers	Avail
233	9/12/2023 11:52	Lori Dement	Alrt(Call)/A
234	9/12/2023 11:52	Lori Dement	Busy(Call)/A
235	9/12/2023 11:55	David Powers	Busy(Call)/A
236	9/12/2023 13:00	Bonnie Bleier	Avail
237	9/12/2023 13:00	Bonnie Bleier	W/U
238	9/12/2023 13:00	Bonnie Bleier	Avail
239	9/12/2023 13:00	Jennifer Leibenguth	N/A
240	9/12/2023 13:07	David Powers	Avail
241	9/12/2023 13:07	David Powers	W/U
242	9/12/2023 13:07	David Powers	Avail
243	9/12/2023 13:08	Lori Dement	Alrt(Call)/A
244	9/12/2023 13:09	Bonnie Bleier	Busy(Call)/A
245	9/12/2023 13:11	David Powers	Alrt(Call)/A
246	9/12/2023 13:11	David Powers	Busy(Call)/A
247	9/12/2023 13:14	Lori Dement	Avail
248	9/12/2023 13:16	Bonnie Bleier	Avail
249	9/12/2023 13:16	Lori Dement	N/A
250	9/12/2023 13:19	Lori Dement	Avail
251	9/12/2023 13:20	David Powers	Avail
252	9/12/2023 13:20	David Powers	W/U
253	9/12/2023 13:20	David Powers	Avail
254	9/12/2023 13:25	Lori Dement	Alrt(Call)/A
255	9/12/2023 13:26	Lori Dement	Busy(Call)/A
256	9/12/2023 13:28	Lori Dement	Avail
257	9/12/2023 13:37	David Powers	Avail
258	9/12/2023 13:42	Bonnie Bleier	Alrt(Call)/A
259	9/12/2023 13:42	Bonnie Bleier	Busy(Call)/A
260	9/12/2023 13:45	Lori Dement	N/A
261	9/12/2023 13:46	Bonnie Bleier	Avail
262	9/12/2023 13:46	Bonnie Bleier	W/U
263	9/12/2023 13:58	David Powers	Avail
264	9/12/2023 16:02	David Powers	Avail
265	9/12/2023 16:04	Marianne Peterson	S/Out
266	9/12/2023 16:04	Marianne Peterson	S/Out
267	9/12/2023 16:04	Marianne Peterson	S/Out
268	9/12/2023 16:04	Marianne Peterson	S/Out
269	9/12/2023 16:59	Bonnie Bleier	Avail
270	9/12/2023 16:59	Jennifer Leibenguth	S/Out
271	9/12/2023 16:59	Jennifer Leibenguth	S/Out
272	9/12/2023 16:59	Jennifer Leibenguth	S/Out
273	9/12/2023 16:59	Jennifer Leibenguth	S/Out
274	9/12/2023 17:29	Bonnie Bleier	Avail
275	9/12/2023 17:29	Bonnie Bleier	W/U
276	9/12/2023 17:29	Bonnie Bleier	Avail
277	9/12/2023 17:30	Lori Dement	S/Out
278	9/12/2023 17:32	David Powers	S/Out
279	9/12/2023 17:32	David Powers	S/Out
280	9/12/2023 17:32	David Powers	S/Out
281	9/12/2023 17:32	David Powers	S/Out
282	9/12/2023 17:32	David Powers	S/Out
283	9/12/2023 17:32	David Powers	S/Out
284	9/12/2023 17:45	Bonnie Bleier	Alrt(Call)/A
285	9/12/2023 18:37	Bonnie Bleier	S/Out
TPx Data

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[pitcrew]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thanks, I will do that. I have both Excel 2014 stand alone as well as Office 365 online Excel, so I can use either one.

 

[Fluff]

I have both Excel 2014

There is no 2014. But for 365 try

Fluff.xlsm
	A	B	C	D	E	F	G
1	Entry Time	Agent Name	State Chg			S/In	S/Out
2	11/09/2023 09:01	Jennifer Leibenguth	S/In		Jennifer Leibenguth	11/09/2023 09:01	12/09/2023 16:59
3	11/09/2023 09:01	Jennifer Leibenguth	N/A		Bonnie Bleier	12/09/2023 09:01	12/09/2023 18:37
4	11/09/2023 09:01	Jennifer Leibenguth	S/In		Lori Dement	11/09/2023 09:29	12/09/2023 17:30
5	11/09/2023 09:01	Jennifer Leibenguth	S/In		David Powers	11/09/2023 09:53	12/09/2023 17:32
6	11/09/2023 09:01	Jennifer Leibenguth	S/In		Marianne Peterson	#CALC!	12/09/2023 16:04
7	11/09/2023 09:01	Jennifer Leibenguth	S/In
8	11/09/2023 09:01	Jennifer Leibenguth	S/In
9	11/09/2023 09:01	Jennifer Leibenguth	S/In
10	11/09/2023 09:01	Jennifer Leibenguth	Avail
11	11/09/2023 09:01	Jennifer Leibenguth	Alrt(Call)/A
12	11/09/2023 09:01	Jennifer Leibenguth	Busy(Call)/A
13	11/09/2023 09:05	Bonnie Bleier	Busy(Call)/A
14	11/09/2023 09:11	Jennifer Leibenguth	Avail
15	11/09/2023 09:11	Jennifer Leibenguth	W/U
16	11/09/2023 09:11	Jennifer Leibenguth	Avail
17	11/09/2023 09:13	Bonnie Bleier	Avail
18	11/09/2023 09:14	Bonnie Bleier	Avail
19	11/09/2023 09:14	Jennifer Leibenguth	Alrt(Call)/A
20	11/09/2023 09:15	Jennifer Leibenguth	Busy(Call)/A
21	11/09/2023 09:18	Jennifer Leibenguth	Avail
22	11/09/2023 09:29	Lori Dement	S/In
23	11/09/2023 09:29	Lori Dement	N/A
24	11/09/2023 09:29	Lori Dement	S/In
25	11/09/2023 09:29	Lori Dement	S/In
26	11/09/2023 09:29	Lori Dement	S/In
27	11/09/2023 09:29	Lori Dement	S/In
28	11/09/2023 09:29	Lori Dement	S/In
29	11/09/2023 09:52	Bonnie Bleier	Avail
30	11/09/2023 09:53	David Powers	S/In
31	11/09/2023 09:53	David Powers	N/A
32	11/09/2023 09:53	David Powers	S/In
33	11/09/2023 09:53	David Powers	S/In
34	11/09/2023 09:53	David Powers	S/In
35	11/09/2023 09:53	David Powers	S/In
36	11/09/2023 09:53	David Powers	S/In
37	11/09/2023 09:54	Jennifer Leibenguth	N/A
38	11/09/2023 09:57	Bonnie Bleier	Alrt(Call)/A
39	11/09/2023 09:57	Bonnie Bleier	Busy(Call)/A
40	11/09/2023 09:57	Jennifer Leibenguth	Avail
41	11/09/2023 10:00	Bonnie Bleier	Avail
42	11/09/2023 10:00	Bonnie Bleier	W/U
43	11/09/2023 11:37	David Powers	Alrt(Call)/A
44	11/09/2023 11:37	Lori Dement	N/A
45	11/09/2023 11:37	David Powers	Busy(Call)/A
46	11/09/2023 11:45	David Powers	Avail
47	11/09/2023 11:45	David Powers	W/U
48	11/09/2023 11:55	Bonnie Bleier	W/U
49	11/09/2023 11:55	Bonnie Bleier	Avail
50	11/09/2023 15:00	Marianne Peterson	S/Out
51	11/09/2023 15:00	Marianne Peterson	S/Out
52	11/09/2023 15:00	Marianne Peterson	S/Out
53	11/09/2023 15:00	Marianne Peterson	S/Out
54	11/09/2023 15:00	Marianne Peterson	S/Out
55	11/09/2023 15:00	Marianne Peterson	S/Out
56	11/09/2023 15:00	Marianne Peterson	S/Out
57	11/09/2023 15:05	David Powers	N/A
58	11/09/2023 15:06	David Powers	Avail
59	11/09/2023 15:12	Bonnie Bleier	Avail
60	11/09/2023 15:12	Bonnie Bleier	W/U
61	11/09/2023 15:12	Bonnie Bleier	Avail
62	11/09/2023 15:14	Bonnie Bleier	Alrt(Call)/A
63	11/09/2023 15:14	Bonnie Bleier	Busy(Call)/A
64	11/09/2023 15:15	Jennifer Leibenguth	Avail
65	11/09/2023 15:15	Jennifer Leibenguth	W/U
66	11/09/2023 15:15	David Powers	Avail
67	11/09/2023 15:15	David Powers	W/U
68	11/09/2023 15:15	Jennifer Leibenguth	Avail
69	11/09/2023 15:15	David Powers	Avail
70	11/09/2023 15:17	Jennifer Leibenguth	N/A
71	11/09/2023 15:19	Bonnie Bleier	Avail
72	11/09/2023 15:20	Bonnie Bleier	Alrt(Call)/A
73	11/09/2023 15:21	Bonnie Bleier	Busy(Call)/A
74	11/09/2023 15:21	Jennifer Leibenguth	Avail
75	11/09/2023 15:21	Bonnie Bleier	Avail
76	11/09/2023 15:32	Jennifer Leibenguth	N/A
77	11/09/2023 15:32	Lori Dement	Alrt(Call)/A
78	11/09/2023 15:32	Lori Dement	Busy(Call)/A
79	11/09/2023 15:37	Lori Dement	Avail
80	11/09/2023 15:37	Lori Dement	W/U
81	11/09/2023 15:38	Lori Dement	Avail
82	11/09/2023 15:46	Bonnie Bleier	W/U
83	11/09/2023 15:46	Bonnie Bleier	Avail
84	11/09/2023 15:48	Lori Dement	Avail
85	11/09/2023 15:48	Lori Dement	W/U
86	11/09/2023 15:48	Lori Dement	Avail
87	11/09/2023 15:51	Bonnie Bleier	Alrt(Call)/A
88	11/09/2023 15:51	Bonnie Bleier	Busy(Call)/A
89	11/09/2023 15:57	Lori Dement	N/A
90	11/09/2023 15:59	Bonnie Bleier	N/A
91	11/09/2023 16:01	Bonnie Bleier	S/Out
92	11/09/2023 16:01	Bonnie Bleier	S/Out
93	11/09/2023 16:01	Bonnie Bleier	S/Out
94	11/09/2023 16:01	Bonnie Bleier	S/Out
95	11/09/2023 16:01	Bonnie Bleier	S/Out
96	11/09/2023 16:01	Bonnie Bleier	S/Out
97	11/09/2023 16:03	David Powers	Avail
98	11/09/2023 16:07	David Powers	Alrt(Call)/A
99	11/09/2023 16:07	David Powers	Busy(Call)/A
100	11/09/2023 16:10	Jennifer Leibenguth	Avail
101	11/09/2023 16:13	David Powers	Avail
102	11/09/2023 16:13	David Powers	W/U
103	11/09/2023 16:13	David Powers	Avail
104	11/09/2023 16:17	Jennifer Leibenguth	Alrt(Call)/A
105	11/09/2023 16:17	Jennifer Leibenguth	Busy(Call)/A
106	11/09/2023 16:20	David Powers	Alrt(Call)/A
107	11/09/2023 16:20	David Powers	Busy(Call)/A
108	11/09/2023 16:23	Jennifer Leibenguth	Avail
109	11/09/2023 16:23	Jennifer Leibenguth	W/U
110	11/09/2023 16:23	Jennifer Leibenguth	Avail
111	11/09/2023 16:33	Jennifer Leibenguth	Alrt(Call)/A
112	11/09/2023 16:33	Jennifer Leibenguth	Busy(Call)/A
113	11/09/2023 16:34	David Powers	Avail
114	11/09/2023 16:34	David Powers	W/U
115	11/09/2023 16:34	David Powers	Avail
116	11/09/2023 16:36	David Powers	Alrt(Call)/A
117	11/09/2023 16:36	Jennifer Leibenguth	Avail
118	11/09/2023 16:36	Jennifer Leibenguth	W/U
119	11/09/2023 16:36	David Powers	Busy(Call)/A
120	11/09/2023 16:37	Jennifer Leibenguth	Avail
121	11/09/2023 16:42	David Powers	Avail
122	11/09/2023 16:42	David Powers	W/U
123	11/09/2023 16:42	David Powers	Avail
124	11/09/2023 16:46	Lori Dement	Avail
125	11/09/2023 16:52	Lori Dement	Alrt(Call)/A
126	11/09/2023 16:52	Lori Dement	Busy(Call)/A
127	11/09/2023 16:52	David Powers	N/A
128	11/09/2023 16:53	Jennifer Leibenguth	Alrt(Call)/A
129	11/09/2023 16:53	Jennifer Leibenguth	Busy(Call)/A
130	11/09/2023 16:57	David Powers	S/Out
131	11/09/2023 16:57	David Powers	S/Out
132	11/09/2023 16:57	David Powers	S/Out
133	11/09/2023 16:57	David Powers	S/Out
134	11/09/2023 16:57	David Powers	S/Out
135	11/09/2023 16:57	David Powers	S/Out
136	11/09/2023 16:57	Jennifer Leibenguth	Avail
137	11/09/2023 16:57	Jennifer Leibenguth	W/U
138	11/09/2023 17:00	Jennifer Leibenguth	Alrt(Call)/A
139	11/09/2023 17:00	Jennifer Leibenguth	Busy(Call)/A
140	11/09/2023 17:00	Lori Dement	Avail
141	11/09/2023 17:00	Lori Dement	W/U
142	11/09/2023 17:01	Lori Dement	Avail
143	11/09/2023 17:04	Lori Dement	Alrt(Call)/A
144	11/09/2023 17:04	Lori Dement	Busy(Call)/A
145	11/09/2023 17:05	Lori Dement	Avail
146	11/09/2023 17:05	Lori Dement	W/U
147	11/09/2023 17:05	Lori Dement	Avail
148	11/09/2023 17:06	Jennifer Leibenguth	Avail
149	11/09/2023 17:06	Jennifer Leibenguth	W/U
150	11/09/2023 17:24	Lori Dement	Avail
151	11/09/2023 17:25	Lori Dement	Alrt(Call)/A
152	11/09/2023 17:25	Lori Dement	Busy(Call)/A
153	11/09/2023 17:29	Jennifer Leibenguth	S/Out
154	11/09/2023 17:29	Jennifer Leibenguth	S/Out
155	11/09/2023 17:29	Jennifer Leibenguth	S/Out
156	11/09/2023 17:29	Jennifer Leibenguth	S/Out
157	11/09/2023 17:43	Lori Dement	Avail
158	11/09/2023 17:43	Lori Dement	Alrt(Call)/A
159	11/09/2023 17:43	Lori Dement	Busy(Call)/A
160	11/09/2023 17:47	Lori Dement	N/A
161	11/09/2023 17:50	David Powers	S/In
162	11/09/2023 17:50	David Powers	N/A
163	11/09/2023 17:50	David Powers	S/In
164	11/09/2023 17:50	David Powers	S/In
165	11/09/2023 17:51	David Powers	Avail
166	11/09/2023 17:51	David Powers	Alrt(Call)/A
167	11/09/2023 17:51	David Powers	Busy(Call)/A
168	11/09/2023 17:51	Lori Dement	S/Out
169	11/09/2023 17:51	Lori Dement	S/Out
170	11/09/2023 17:51	Lori Dement	S/Out
171	12/09/2023 09:01	Bonnie Bleier	S/In
172	12/09/2023 09:01	Bonnie Bleier	S/In
173	12/09/2023 09:01	Bonnie Bleier	S/In
174	12/09/2023 09:24	David Powers	S/In
175	12/09/2023 09:24	David Powers	N/A
176	12/09/2023 09:24	David Powers	S/In
177	12/09/2023 09:24	David Powers	S/In
178	12/09/2023 09:27	Jennifer Leibenguth	S/In
179	12/09/2023 09:27	Jennifer Leibenguth	N/A
180	12/09/2023 09:27	Jennifer Leibenguth	S/In
181	12/09/2023 09:49	Lori Dement	Busy(Call)/A
182	12/09/2023 09:50	David Powers	Alrt(Call)/A
183	12/09/2023 09:50	David Powers	Busy(Call)/A
184	12/09/2023 09:52	Bonnie Bleier	S/Out
185	12/09/2023 09:52	Bonnie Bleier	S/Out
186	12/09/2023 09:52	Bonnie Bleier	S/Out
187	12/09/2023 09:52	Bonnie Bleier	S/Out
188	12/09/2023 09:52	David Powers	Avail
189	12/09/2023 09:52	David Powers	W/U
190	12/09/2023 09:52	David Powers	Avail
191	12/09/2023 09:53	David Powers	Alrt(Call)/A
192	12/09/2023 09:53	David Powers	Busy(Call)/A
193	12/09/2023 09:53	David Powers	Avail
194	12/09/2023 09:54	Lori Dement	Avail
195	12/09/2023 09:58	David Powers	Alrt(Call)/A
196	12/09/2023 09:58	David Powers	Busy(Call)/A
197	12/09/2023 09:59	David Powers	Avail
198	12/09/2023 09:59	David Powers	W/U
199	12/09/2023 09:59	Lori Dement	Alrt(Call)/A
200	12/09/2023 09:59	Lori Dement	Busy(Call)/A
201	12/09/2023 09:59	David Powers	Avail
202	12/09/2023 09:59	David Powers	Alrt(Call)/A
203	12/09/2023 09:59	David Powers	Busy(Call)/A
204	12/09/2023 10:37	Lori Dement	Avail
205	12/09/2023 10:37	Lori Dement	Alrt(Call)/A
206	12/09/2023 10:37	Lori Dement	Busy(Call)/A
207	12/09/2023 10:41	Bonnie Bleier	S/In
208	12/09/2023 10:41	Bonnie Bleier	S/In
209	12/09/2023 10:41	Bonnie Bleier	Alrt(Call)/A
210	12/09/2023 10:41	Bonnie Bleier	Busy(Call)/A
211	12/09/2023 10:43	Lori Dement	Avail
212	12/09/2023 10:43	Lori Dement	W/U
213	12/09/2023 10:43	Lori Dement	Avail
214	12/09/2023 10:45	Lori Dement	Alrt(Call)/A
215	12/09/2023 10:45	Lori Dement	Busy(Call)/A
216	12/09/2023 10:45	Bonnie Bleier	Avail
217	12/09/2023 10:45	Bonnie Bleier	W/U
218	12/09/2023 10:45	Bonnie Bleier	Avail
219	12/09/2023 10:51	Lori Dement	Avail
220	12/09/2023 10:51	Lori Dement	W/U
221	12/09/2023 10:51	Lori Dement	Avail
222	12/09/2023 10:52	Lori Dement	Alrt(Call)/A
223	12/09/2023 10:52	Lori Dement	Busy(Call)/A
224	12/09/2023 10:54	Bonnie Bleier	Alrt(Call)/A
225	12/09/2023 11:00	Bonnie Bleier	Busy(Call)/A
226	12/09/2023 11:03	Lori Dement	N/A
227	12/09/2023 11:10	Bonnie Bleier	Avail
228	12/09/2023 11:10	Bonnie Bleier	W/U
229	12/09/2023 11:10	Bonnie Bleier	Avail
230	12/09/2023 11:51	David Powers	Avail
231	12/09/2023 11:51	David Powers	W/U
232	12/09/2023 11:51	David Powers	Avail
233	12/09/2023 11:52	Lori Dement	Alrt(Call)/A
234	12/09/2023 11:52	Lori Dement	Busy(Call)/A
235	12/09/2023 11:55	David Powers	Busy(Call)/A
236	12/09/2023 13:00	Bonnie Bleier	Avail
237	12/09/2023 13:00	Bonnie Bleier	W/U
238	12/09/2023 13:00	Bonnie Bleier	Avail
239	12/09/2023 13:00	Jennifer Leibenguth	N/A
240	12/09/2023 13:07	David Powers	Avail
241	12/09/2023 13:07	David Powers	W/U
242	12/09/2023 13:07	David Powers	Avail
243	12/09/2023 13:08	Lori Dement	Alrt(Call)/A
244	12/09/2023 13:09	Bonnie Bleier	Busy(Call)/A
245	12/09/2023 13:11	David Powers	Alrt(Call)/A
246	12/09/2023 13:11	David Powers	Busy(Call)/A
247	12/09/2023 13:14	Lori Dement	Avail
248	12/09/2023 13:16	Bonnie Bleier	Avail
249	12/09/2023 13:16	Lori Dement	N/A
250	12/09/2023 13:19	Lori Dement	Avail
251	12/09/2023 13:20	David Powers	Avail
252	12/09/2023 13:20	David Powers	W/U
253	12/09/2023 13:20	David Powers	Avail
254	12/09/2023 13:25	Lori Dement	Alrt(Call)/A
255	12/09/2023 13:26	Lori Dement	Busy(Call)/A
256	12/09/2023 13:28	Lori Dement	Avail
257	12/09/2023 13:37	David Powers	Avail
258	12/09/2023 13:42	Bonnie Bleier	Alrt(Call)/A
259	12/09/2023 13:42	Bonnie Bleier	Busy(Call)/A
260	12/09/2023 13:45	Lori Dement	N/A
261	12/09/2023 13:46	Bonnie Bleier	Avail
262	12/09/2023 13:46	Bonnie Bleier	W/U
263	12/09/2023 13:58	David Powers	Avail
264	12/09/2023 16:02	David Powers	Avail
265	12/09/2023 16:04	Marianne Peterson	S/Out
266	12/09/2023 16:04	Marianne Peterson	S/Out
267	12/09/2023 16:04	Marianne Peterson	S/Out
268	12/09/2023 16:04	Marianne Peterson	S/Out
269	12/09/2023 16:59	Bonnie Bleier	Avail
270	12/09/2023 16:59	Jennifer Leibenguth	S/Out
271	12/09/2023 16:59	Jennifer Leibenguth	S/Out
272	12/09/2023 16:59	Jennifer Leibenguth	S/Out
273	12/09/2023 16:59	Jennifer Leibenguth	S/Out
274	12/09/2023 17:29	Bonnie Bleier	Avail
275	12/09/2023 17:29	Bonnie Bleier	W/U
276	12/09/2023 17:29	Bonnie Bleier	Avail
277	12/09/2023 17:30	Lori Dement	S/Out
278	12/09/2023 17:32	David Powers	S/Out
279	12/09/2023 17:32	David Powers	S/Out
280	12/09/2023 17:32	David Powers	S/Out
281	12/09/2023 17:32	David Powers	S/Out
282	12/09/2023 17:32	David Powers	S/Out
283	12/09/2023 17:32	David Powers	S/Out
284	12/09/2023 17:45	Bonnie Bleier	Alrt(Call)/A
285	12/09/2023 18:37	Bonnie Bleier	S/Out
Sheet6

Cell Formulas
Range	Formula
E2:E6	E2	=UNIQUE(B2:B285)
F2:F6	F2	=TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=F$1)),1)
G2:G6	G2	=TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=G$1)),-1)
Dynamic array formulas.

 

[pitcrew]

There is no 2014. But for 365 try

Fluff.xlsm
	A	B	C	D	E	F	G
1	Entry Time	Agent Name	State Chg			S/In	S/Out
2	11/09/2023 09:01	Jennifer Leibenguth	S/In		Jennifer Leibenguth	11/09/2023 09:01	12/09/2023 16:59
3	11/09/2023 09:01	Jennifer Leibenguth	N/A		Bonnie Bleier	12/09/2023 09:01	12/09/2023 18:37
4	11/09/2023 09:01	Jennifer Leibenguth	S/In		Lori Dement	11/09/2023 09:29	12/09/2023 17:30
5	11/09/2023 09:01	Jennifer Leibenguth	S/In		David Powers	11/09/2023 09:53	12/09/2023 17:32
6	11/09/2023 09:01	Jennifer Leibenguth	S/In		Marianne Peterson	#CALC!	12/09/2023 16:04
7	11/09/2023 09:01	Jennifer Leibenguth	S/In
8	11/09/2023 09:01	Jennifer Leibenguth	S/In
9	11/09/2023 09:01	Jennifer Leibenguth	S/In
10	11/09/2023 09:01	Jennifer Leibenguth	Avail
11	11/09/2023 09:01	Jennifer Leibenguth	Alrt(Call)/A
12	11/09/2023 09:01	Jennifer Leibenguth	Busy(Call)/A
13	11/09/2023 09:05	Bonnie Bleier	Busy(Call)/A
14	11/09/2023 09:11	Jennifer Leibenguth	Avail
15	11/09/2023 09:11	Jennifer Leibenguth	W/U
16	11/09/2023 09:11	Jennifer Leibenguth	Avail
17	11/09/2023 09:13	Bonnie Bleier	Avail
18	11/09/2023 09:14	Bonnie Bleier	Avail
19	11/09/2023 09:14	Jennifer Leibenguth	Alrt(Call)/A
20	11/09/2023 09:15	Jennifer Leibenguth	Busy(Call)/A
21	11/09/2023 09:18	Jennifer Leibenguth	Avail
22	11/09/2023 09:29	Lori Dement	S/In
23	11/09/2023 09:29	Lori Dement	N/A
24	11/09/2023 09:29	Lori Dement	S/In
25	11/09/2023 09:29	Lori Dement	S/In
26	11/09/2023 09:29	Lori Dement	S/In
27	11/09/2023 09:29	Lori Dement	S/In
28	11/09/2023 09:29	Lori Dement	S/In
29	11/09/2023 09:52	Bonnie Bleier	Avail
30	11/09/2023 09:53	David Powers	S/In
31	11/09/2023 09:53	David Powers	N/A
32	11/09/2023 09:53	David Powers	S/In
33	11/09/2023 09:53	David Powers	S/In
34	11/09/2023 09:53	David Powers	S/In
35	11/09/2023 09:53	David Powers	S/In
36	11/09/2023 09:53	David Powers	S/In
37	11/09/2023 09:54	Jennifer Leibenguth	N/A
38	11/09/2023 09:57	Bonnie Bleier	Alrt(Call)/A
39	11/09/2023 09:57	Bonnie Bleier	Busy(Call)/A
40	11/09/2023 09:57	Jennifer Leibenguth	Avail
41	11/09/2023 10:00	Bonnie Bleier	Avail
42	11/09/2023 10:00	Bonnie Bleier	W/U
43	11/09/2023 11:37	David Powers	Alrt(Call)/A
44	11/09/2023 11:37	Lori Dement	N/A
45	11/09/2023 11:37	David Powers	Busy(Call)/A
46	11/09/2023 11:45	David Powers	Avail
47	11/09/2023 11:45	David Powers	W/U
48	11/09/2023 11:55	Bonnie Bleier	W/U
49	11/09/2023 11:55	Bonnie Bleier	Avail
50	11/09/2023 15:00	Marianne Peterson	S/Out
51	11/09/2023 15:00	Marianne Peterson	S/Out
52	11/09/2023 15:00	Marianne Peterson	S/Out
53	11/09/2023 15:00	Marianne Peterson	S/Out
54	11/09/2023 15:00	Marianne Peterson	S/Out
55	11/09/2023 15:00	Marianne Peterson	S/Out
56	11/09/2023 15:00	Marianne Peterson	S/Out
57	11/09/2023 15:05	David Powers	N/A
58	11/09/2023 15:06	David Powers	Avail
59	11/09/2023 15:12	Bonnie Bleier	Avail
60	11/09/2023 15:12	Bonnie Bleier	W/U
61	11/09/2023 15:12	Bonnie Bleier	Avail
62	11/09/2023 15:14	Bonnie Bleier	Alrt(Call)/A
63	11/09/2023 15:14	Bonnie Bleier	Busy(Call)/A
64	11/09/2023 15:15	Jennifer Leibenguth	Avail
65	11/09/2023 15:15	Jennifer Leibenguth	W/U
66	11/09/2023 15:15	David Powers	Avail
67	11/09/2023 15:15	David Powers	W/U
68	11/09/2023 15:15	Jennifer Leibenguth	Avail
69	11/09/2023 15:15	David Powers	Avail
70	11/09/2023 15:17	Jennifer Leibenguth	N/A
71	11/09/2023 15:19	Bonnie Bleier	Avail
72	11/09/2023 15:20	Bonnie Bleier	Alrt(Call)/A
73	11/09/2023 15:21	Bonnie Bleier	Busy(Call)/A
74	11/09/2023 15:21	Jennifer Leibenguth	Avail
75	11/09/2023 15:21	Bonnie Bleier	Avail
76	11/09/2023 15:32	Jennifer Leibenguth	N/A
77	11/09/2023 15:32	Lori Dement	Alrt(Call)/A
78	11/09/2023 15:32	Lori Dement	Busy(Call)/A
79	11/09/2023 15:37	Lori Dement	Avail
80	11/09/2023 15:37	Lori Dement	W/U
81	11/09/2023 15:38	Lori Dement	Avail
82	11/09/2023 15:46	Bonnie Bleier	W/U
83	11/09/2023 15:46	Bonnie Bleier	Avail
84	11/09/2023 15:48	Lori Dement	Avail
85	11/09/2023 15:48	Lori Dement	W/U
86	11/09/2023 15:48	Lori Dement	Avail
87	11/09/2023 15:51	Bonnie Bleier	Alrt(Call)/A
88	11/09/2023 15:51	Bonnie Bleier	Busy(Call)/A
89	11/09/2023 15:57	Lori Dement	N/A
90	11/09/2023 15:59	Bonnie Bleier	N/A
91	11/09/2023 16:01	Bonnie Bleier	S/Out
92	11/09/2023 16:01	Bonnie Bleier	S/Out
93	11/09/2023 16:01	Bonnie Bleier	S/Out
94	11/09/2023 16:01	Bonnie Bleier	S/Out
95	11/09/2023 16:01	Bonnie Bleier	S/Out
96	11/09/2023 16:01	Bonnie Bleier	S/Out
97	11/09/2023 16:03	David Powers	Avail
98	11/09/2023 16:07	David Powers	Alrt(Call)/A
99	11/09/2023 16:07	David Powers	Busy(Call)/A
100	11/09/2023 16:10	Jennifer Leibenguth	Avail
101	11/09/2023 16:13	David Powers	Avail
102	11/09/2023 16:13	David Powers	W/U
103	11/09/2023 16:13	David Powers	Avail
104	11/09/2023 16:17	Jennifer Leibenguth	Alrt(Call)/A
105	11/09/2023 16:17	Jennifer Leibenguth	Busy(Call)/A
106	11/09/2023 16:20	David Powers	Alrt(Call)/A
107	11/09/2023 16:20	David Powers	Busy(Call)/A
108	11/09/2023 16:23	Jennifer Leibenguth	Avail
109	11/09/2023 16:23	Jennifer Leibenguth	W/U
110	11/09/2023 16:23	Jennifer Leibenguth	Avail
111	11/09/2023 16:33	Jennifer Leibenguth	Alrt(Call)/A
112	11/09/2023 16:33	Jennifer Leibenguth	Busy(Call)/A
113	11/09/2023 16:34	David Powers	Avail
114	11/09/2023 16:34	David Powers	W/U
115	11/09/2023 16:34	David Powers	Avail
116	11/09/2023 16:36	David Powers	Alrt(Call)/A
117	11/09/2023 16:36	Jennifer Leibenguth	Avail
118	11/09/2023 16:36	Jennifer Leibenguth	W/U
119	11/09/2023 16:36	David Powers	Busy(Call)/A
120	11/09/2023 16:37	Jennifer Leibenguth	Avail
121	11/09/2023 16:42	David Powers	Avail
122	11/09/2023 16:42	David Powers	W/U
123	11/09/2023 16:42	David Powers	Avail
124	11/09/2023 16:46	Lori Dement	Avail
125	11/09/2023 16:52	Lori Dement	Alrt(Call)/A
126	11/09/2023 16:52	Lori Dement	Busy(Call)/A
127	11/09/2023 16:52	David Powers	N/A
128	11/09/2023 16:53	Jennifer Leibenguth	Alrt(Call)/A
129	11/09/2023 16:53	Jennifer Leibenguth	Busy(Call)/A
130	11/09/2023 16:57	David Powers	S/Out
131	11/09/2023 16:57	David Powers	S/Out
132	11/09/2023 16:57	David Powers	S/Out
133	11/09/2023 16:57	David Powers	S/Out
134	11/09/2023 16:57	David Powers	S/Out
135	11/09/2023 16:57	David Powers	S/Out
136	11/09/2023 16:57	Jennifer Leibenguth	Avail
137	11/09/2023 16:57	Jennifer Leibenguth	W/U
138	11/09/2023 17:00	Jennifer Leibenguth	Alrt(Call)/A
139	11/09/2023 17:00	Jennifer Leibenguth	Busy(Call)/A
140	11/09/2023 17:00	Lori Dement	Avail
141	11/09/2023 17:00	Lori Dement	W/U
142	11/09/2023 17:01	Lori Dement	Avail
143	11/09/2023 17:04	Lori Dement	Alrt(Call)/A
144	11/09/2023 17:04	Lori Dement	Busy(Call)/A
145	11/09/2023 17:05	Lori Dement	Avail
146	11/09/2023 17:05	Lori Dement	W/U
147	11/09/2023 17:05	Lori Dement	Avail
148	11/09/2023 17:06	Jennifer Leibenguth	Avail
149	11/09/2023 17:06	Jennifer Leibenguth	W/U
150	11/09/2023 17:24	Lori Dement	Avail
151	11/09/2023 17:25	Lori Dement	Alrt(Call)/A
152	11/09/2023 17:25	Lori Dement	Busy(Call)/A
153	11/09/2023 17:29	Jennifer Leibenguth	S/Out
154	11/09/2023 17:29	Jennifer Leibenguth	S/Out
155	11/09/2023 17:29	Jennifer Leibenguth	S/Out
156	11/09/2023 17:29	Jennifer Leibenguth	S/Out
157	11/09/2023 17:43	Lori Dement	Avail
158	11/09/2023 17:43	Lori Dement	Alrt(Call)/A
159	11/09/2023 17:43	Lori Dement	Busy(Call)/A
160	11/09/2023 17:47	Lori Dement	N/A
161	11/09/2023 17:50	David Powers	S/In
162	11/09/2023 17:50	David Powers	N/A
163	11/09/2023 17:50	David Powers	S/In
164	11/09/2023 17:50	David Powers	S/In
165	11/09/2023 17:51	David Powers	Avail
166	11/09/2023 17:51	David Powers	Alrt(Call)/A
167	11/09/2023 17:51	David Powers	Busy(Call)/A
168	11/09/2023 17:51	Lori Dement	S/Out
169	11/09/2023 17:51	Lori Dement	S/Out
170	11/09/2023 17:51	Lori Dement	S/Out
171	12/09/2023 09:01	Bonnie Bleier	S/In
172	12/09/2023 09:01	Bonnie Bleier	S/In
173	12/09/2023 09:01	Bonnie Bleier	S/In
174	12/09/2023 09:24	David Powers	S/In
175	12/09/2023 09:24	David Powers	N/A
176	12/09/2023 09:24	David Powers	S/In
177	12/09/2023 09:24	David Powers	S/In
178	12/09/2023 09:27	Jennifer Leibenguth	S/In
179	12/09/2023 09:27	Jennifer Leibenguth	N/A
180	12/09/2023 09:27	Jennifer Leibenguth	S/In
181	12/09/2023 09:49	Lori Dement	Busy(Call)/A
182	12/09/2023 09:50	David Powers	Alrt(Call)/A
183	12/09/2023 09:50	David Powers	Busy(Call)/A
184	12/09/2023 09:52	Bonnie Bleier	S/Out
185	12/09/2023 09:52	Bonnie Bleier	S/Out
186	12/09/2023 09:52	Bonnie Bleier	S/Out
187	12/09/2023 09:52	Bonnie Bleier	S/Out
188	12/09/2023 09:52	David Powers	Avail
189	12/09/2023 09:52	David Powers	W/U
190	12/09/2023 09:52	David Powers	Avail
191	12/09/2023 09:53	David Powers	Alrt(Call)/A
192	12/09/2023 09:53	David Powers	Busy(Call)/A
193	12/09/2023 09:53	David Powers	Avail
194	12/09/2023 09:54	Lori Dement	Avail
195	12/09/2023 09:58	David Powers	Alrt(Call)/A
196	12/09/2023 09:58	David Powers	Busy(Call)/A
197	12/09/2023 09:59	David Powers	Avail
198	12/09/2023 09:59	David Powers	W/U
199	12/09/2023 09:59	Lori Dement	Alrt(Call)/A
200	12/09/2023 09:59	Lori Dement	Busy(Call)/A
201	12/09/2023 09:59	David Powers	Avail
202	12/09/2023 09:59	David Powers	Alrt(Call)/A
203	12/09/2023 09:59	David Powers	Busy(Call)/A
204	12/09/2023 10:37	Lori Dement	Avail
205	12/09/2023 10:37	Lori Dement	Alrt(Call)/A
206	12/09/2023 10:37	Lori Dement	Busy(Call)/A
207	12/09/2023 10:41	Bonnie Bleier	S/In
208	12/09/2023 10:41	Bonnie Bleier	S/In
209	12/09/2023 10:41	Bonnie Bleier	Alrt(Call)/A
210	12/09/2023 10:41	Bonnie Bleier	Busy(Call)/A
211	12/09/2023 10:43	Lori Dement	Avail
212	12/09/2023 10:43	Lori Dement	W/U
213	12/09/2023 10:43	Lori Dement	Avail
214	12/09/2023 10:45	Lori Dement	Alrt(Call)/A
215	12/09/2023 10:45	Lori Dement	Busy(Call)/A
216	12/09/2023 10:45	Bonnie Bleier	Avail
217	12/09/2023 10:45	Bonnie Bleier	W/U
218	12/09/2023 10:45	Bonnie Bleier	Avail
219	12/09/2023 10:51	Lori Dement	Avail
220	12/09/2023 10:51	Lori Dement	W/U
221	12/09/2023 10:51	Lori Dement	Avail
222	12/09/2023 10:52	Lori Dement	Alrt(Call)/A
223	12/09/2023 10:52	Lori Dement	Busy(Call)/A
224	12/09/2023 10:54	Bonnie Bleier	Alrt(Call)/A
225	12/09/2023 11:00	Bonnie Bleier	Busy(Call)/A
226	12/09/2023 11:03	Lori Dement	N/A
227	12/09/2023 11:10	Bonnie Bleier	Avail
228	12/09/2023 11:10	Bonnie Bleier	W/U
229	12/09/2023 11:10	Bonnie Bleier	Avail
230	12/09/2023 11:51	David Powers	Avail
231	12/09/2023 11:51	David Powers	W/U
232	12/09/2023 11:51	David Powers	Avail
233	12/09/2023 11:52	Lori Dement	Alrt(Call)/A
234	12/09/2023 11:52	Lori Dement	Busy(Call)/A
235	12/09/2023 11:55	David Powers	Busy(Call)/A
236	12/09/2023 13:00	Bonnie Bleier	Avail
237	12/09/2023 13:00	Bonnie Bleier	W/U
238	12/09/2023 13:00	Bonnie Bleier	Avail
239	12/09/2023 13:00	Jennifer Leibenguth	N/A
240	12/09/2023 13:07	David Powers	Avail
241	12/09/2023 13:07	David Powers	W/U
242	12/09/2023 13:07	David Powers	Avail
243	12/09/2023 13:08	Lori Dement	Alrt(Call)/A
244	12/09/2023 13:09	Bonnie Bleier	Busy(Call)/A
245	12/09/2023 13:11	David Powers	Alrt(Call)/A
246	12/09/2023 13:11	David Powers	Busy(Call)/A
247	12/09/2023 13:14	Lori Dement	Avail
248	12/09/2023 13:16	Bonnie Bleier	Avail
249	12/09/2023 13:16	Lori Dement	N/A
250	12/09/2023 13:19	Lori Dement	Avail
251	12/09/2023 13:20	David Powers	Avail
252	12/09/2023 13:20	David Powers	W/U
253	12/09/2023 13:20	David Powers	Avail
254	12/09/2023 13:25	Lori Dement	Alrt(Call)/A
255	12/09/2023 13:26	Lori Dement	Busy(Call)/A
256	12/09/2023 13:28	Lori Dement	Avail
257	12/09/2023 13:37	David Powers	Avail
258	12/09/2023 13:42	Bonnie Bleier	Alrt(Call)/A
259	12/09/2023 13:42	Bonnie Bleier	Busy(Call)/A
260	12/09/2023 13:45	Lori Dement	N/A
261	12/09/2023 13:46	Bonnie Bleier	Avail
262	12/09/2023 13:46	Bonnie Bleier	W/U
263	12/09/2023 13:58	David Powers	Avail
264	12/09/2023 16:02	David Powers	Avail
265	12/09/2023 16:04	Marianne Peterson	S/Out
266	12/09/2023 16:04	Marianne Peterson	S/Out
267	12/09/2023 16:04	Marianne Peterson	S/Out
268	12/09/2023 16:04	Marianne Peterson	S/Out
269	12/09/2023 16:59	Bonnie Bleier	Avail
270	12/09/2023 16:59	Jennifer Leibenguth	S/Out
271	12/09/2023 16:59	Jennifer Leibenguth	S/Out
272	12/09/2023 16:59	Jennifer Leibenguth	S/Out
273	12/09/2023 16:59	Jennifer Leibenguth	S/Out
274	12/09/2023 17:29	Bonnie Bleier	Avail
275	12/09/2023 17:29	Bonnie Bleier	W/U
276	12/09/2023 17:29	Bonnie Bleier	Avail
277	12/09/2023 17:30	Lori Dement	S/Out
278	12/09/2023 17:32	David Powers	S/Out
279	12/09/2023 17:32	David Powers	S/Out
280	12/09/2023 17:32	David Powers	S/Out
281	12/09/2023 17:32	David Powers	S/Out
282	12/09/2023 17:32	David Powers	S/Out
283	12/09/2023 17:32	David Powers	S/Out
284	12/09/2023 17:45	Bonnie Bleier	Alrt(Call)/A
285	12/09/2023 18:37	Bonnie Bleier	S/Out
Sheet6

Cell Formulas
Range	Formula
E2:E6	E2	=UNIQUE(B2:B285)
F2:F6	F2	=TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=F$1)),1)
G2:G6	G2	=TAKE(FILTER($A$2:$A$400,($B$2:$B$400=$E2)*($C$2:$C$400=G$1)),-1)
Dynamic array formulas.

The only problem with this is that it is not showing the earliest login and latest logout for each individual day. For example, I need to know What Time Jennifer signed-in to start her day on 9/11/23 and what time she last signed-out on that same day. Then I need that information for the next day and so on for the week. Same for every other employee.

 

[Fluff]

Missed that part, try

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Entry Time	Agent Name	State Chg				S/In	S/Out
2	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	Jennifer Leibenguth	11/09/2023 09:01	11/09/2023 17:29
3	11/09/2023 09:01	Jennifer Leibenguth	N/A		11/09/2023	Bonnie Bleier	#CALC!	11/09/2023 16:01
4	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	Lori Dement	11/09/2023 09:29	11/09/2023 17:51
5	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	David Powers	11/09/2023 09:53	11/09/2023 16:57
6	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	Marianne Peterson	#CALC!	11/09/2023 15:00
7	11/09/2023 09:01	Jennifer Leibenguth	S/In		12/09/2023	Bonnie Bleier	12/09/2023 09:01	12/09/2023 09:52
8	11/09/2023 09:01	Jennifer Leibenguth	S/In		12/09/2023	David Powers	12/09/2023 09:24	12/09/2023 17:32
9	11/09/2023 09:01	Jennifer Leibenguth	S/In		12/09/2023	Jennifer Leibenguth	12/09/2023 09:27	12/09/2023 16:59
10	11/09/2023 09:01	Jennifer Leibenguth	Avail		12/09/2023	Lori Dement	#CALC!	12/09/2023 17:30
11	11/09/2023 09:01	Jennifer Leibenguth	Alrt(Call)/A		12/09/2023	Marianne Peterson	#CALC!	12/09/2023 16:04
12	11/09/2023 09:01	Jennifer Leibenguth	Busy(Call)/A
13	11/09/2023 09:05	Bonnie Bleier	Busy(Call)/A
14	11/09/2023 09:11	Jennifer Leibenguth	Avail
15	11/09/2023 09:11	Jennifer Leibenguth	W/U
16	11/09/2023 09:11	Jennifer Leibenguth	Avail
17	11/09/2023 09:13	Bonnie Bleier	Avail
18	11/09/2023 09:14	Bonnie Bleier	Avail
19	11/09/2023 09:14	Jennifer Leibenguth	Alrt(Call)/A
20	11/09/2023 09:15	Jennifer Leibenguth	Busy(Call)/A
21	11/09/2023 09:18	Jennifer Leibenguth	Avail
22	11/09/2023 09:29	Lori Dement	S/In
23	11/09/2023 09:29	Lori Dement	N/A
24	11/09/2023 09:29	Lori Dement	S/In
25	11/09/2023 09:29	Lori Dement	S/In
26	11/09/2023 09:29	Lori Dement	S/In
27	11/09/2023 09:29	Lori Dement	S/In
28	11/09/2023 09:29	Lori Dement	S/In
29	11/09/2023 09:52	Bonnie Bleier	Avail
30	11/09/2023 09:53	David Powers	S/In
31	11/09/2023 09:53	David Powers	N/A
32	11/09/2023 09:53	David Powers	S/In
33	11/09/2023 09:53	David Powers	S/In
34	11/09/2023 09:53	David Powers	S/In
35	11/09/2023 09:53	David Powers	S/In
36	11/09/2023 09:53	David Powers	S/In
37	11/09/2023 09:54	Jennifer Leibenguth	N/A
38	11/09/2023 09:57	Bonnie Bleier	Alrt(Call)/A
39	11/09/2023 09:57	Bonnie Bleier	Busy(Call)/A
40	11/09/2023 09:57	Jennifer Leibenguth	Avail
41	11/09/2023 10:00	Bonnie Bleier	Avail
42	11/09/2023 10:00	Bonnie Bleier	W/U
43	11/09/2023 11:37	David Powers	Alrt(Call)/A
44	11/09/2023 11:37	Lori Dement	N/A
45	11/09/2023 11:37	David Powers	Busy(Call)/A
46	11/09/2023 11:45	David Powers	Avail
47	11/09/2023 11:45	David Powers	W/U
48	11/09/2023 11:55	Bonnie Bleier	W/U
49	11/09/2023 11:55	Bonnie Bleier	Avail
50	11/09/2023 15:00	Marianne Peterson	S/Out
51	11/09/2023 15:00	Marianne Peterson	S/Out
52	11/09/2023 15:00	Marianne Peterson	S/Out
53	11/09/2023 15:00	Marianne Peterson	S/Out
54	11/09/2023 15:00	Marianne Peterson	S/Out
55	11/09/2023 15:00	Marianne Peterson	S/Out
56	11/09/2023 15:00	Marianne Peterson	S/Out
57	11/09/2023 15:05	David Powers	N/A
58	11/09/2023 15:06	David Powers	Avail
59	11/09/2023 15:12	Bonnie Bleier	Avail
60	11/09/2023 15:12	Bonnie Bleier	W/U
61	11/09/2023 15:12	Bonnie Bleier	Avail
62	11/09/2023 15:14	Bonnie Bleier	Alrt(Call)/A
63	11/09/2023 15:14	Bonnie Bleier	Busy(Call)/A
64	11/09/2023 15:15	Jennifer Leibenguth	Avail
65	11/09/2023 15:15	Jennifer Leibenguth	W/U
66	11/09/2023 15:15	David Powers	Avail
67	11/09/2023 15:15	David Powers	W/U
68	11/09/2023 15:15	Jennifer Leibenguth	Avail
69	11/09/2023 15:15	David Powers	Avail
70	11/09/2023 15:17	Jennifer Leibenguth	N/A
71	11/09/2023 15:19	Bonnie Bleier	Avail
72	11/09/2023 15:20	Bonnie Bleier	Alrt(Call)/A
73	11/09/2023 15:21	Bonnie Bleier	Busy(Call)/A
74	11/09/2023 15:21	Jennifer Leibenguth	Avail
75	11/09/2023 15:21	Bonnie Bleier	Avail
76	11/09/2023 15:32	Jennifer Leibenguth	N/A
77	11/09/2023 15:32	Lori Dement	Alrt(Call)/A
78	11/09/2023 15:32	Lori Dement	Busy(Call)/A
79	11/09/2023 15:37	Lori Dement	Avail
80	11/09/2023 15:37	Lori Dement	W/U
81	11/09/2023 15:38	Lori Dement	Avail
82	11/09/2023 15:46	Bonnie Bleier	W/U
83	11/09/2023 15:46	Bonnie Bleier	Avail
84	11/09/2023 15:48	Lori Dement	Avail
85	11/09/2023 15:48	Lori Dement	W/U
86	11/09/2023 15:48	Lori Dement	Avail
87	11/09/2023 15:51	Bonnie Bleier	Alrt(Call)/A
88	11/09/2023 15:51	Bonnie Bleier	Busy(Call)/A
89	11/09/2023 15:57	Lori Dement	N/A
90	11/09/2023 15:59	Bonnie Bleier	N/A
91	11/09/2023 16:01	Bonnie Bleier	S/Out
92	11/09/2023 16:01	Bonnie Bleier	S/Out
93	11/09/2023 16:01	Bonnie Bleier	S/Out
94	11/09/2023 16:01	Bonnie Bleier	S/Out
95	11/09/2023 16:01	Bonnie Bleier	S/Out
96	11/09/2023 16:01	Bonnie Bleier	S/Out
97	11/09/2023 16:03	David Powers	Avail
98	11/09/2023 16:07	David Powers	Alrt(Call)/A
99	11/09/2023 16:07	David Powers	Busy(Call)/A
100	11/09/2023 16:10	Jennifer Leibenguth	Avail
101	11/09/2023 16:13	David Powers	Avail
102	11/09/2023 16:13	David Powers	W/U
103	11/09/2023 16:13	David Powers	Avail
104	11/09/2023 16:17	Jennifer Leibenguth	Alrt(Call)/A
105	11/09/2023 16:17	Jennifer Leibenguth	Busy(Call)/A
106	11/09/2023 16:20	David Powers	Alrt(Call)/A
107	11/09/2023 16:20	David Powers	Busy(Call)/A
108	11/09/2023 16:23	Jennifer Leibenguth	Avail
109	11/09/2023 16:23	Jennifer Leibenguth	W/U
110	11/09/2023 16:23	Jennifer Leibenguth	Avail
111	11/09/2023 16:33	Jennifer Leibenguth	Alrt(Call)/A
112	11/09/2023 16:33	Jennifer Leibenguth	Busy(Call)/A
113	11/09/2023 16:34	David Powers	Avail
114	11/09/2023 16:34	David Powers	W/U
115	11/09/2023 16:34	David Powers	Avail
116	11/09/2023 16:36	David Powers	Alrt(Call)/A
117	11/09/2023 16:36	Jennifer Leibenguth	Avail
118	11/09/2023 16:36	Jennifer Leibenguth	W/U
119	11/09/2023 16:36	David Powers	Busy(Call)/A
120	11/09/2023 16:37	Jennifer Leibenguth	Avail
121	11/09/2023 16:42	David Powers	Avail
122	11/09/2023 16:42	David Powers	W/U
123	11/09/2023 16:42	David Powers	Avail
124	11/09/2023 16:46	Lori Dement	Avail
125	11/09/2023 16:52	Lori Dement	Alrt(Call)/A
126	11/09/2023 16:52	Lori Dement	Busy(Call)/A
127	11/09/2023 16:52	David Powers	N/A
128	11/09/2023 16:53	Jennifer Leibenguth	Alrt(Call)/A
129	11/09/2023 16:53	Jennifer Leibenguth	Busy(Call)/A
130	11/09/2023 16:57	David Powers	S/Out
131	11/09/2023 16:57	David Powers	S/Out
132	11/09/2023 16:57	David Powers	S/Out
133	11/09/2023 16:57	David Powers	S/Out
134	11/09/2023 16:57	David Powers	S/Out
135	11/09/2023 16:57	David Powers	S/Out
136	11/09/2023 16:57	Jennifer Leibenguth	Avail
137	11/09/2023 16:57	Jennifer Leibenguth	W/U
138	11/09/2023 17:00	Jennifer Leibenguth	Alrt(Call)/A
139	11/09/2023 17:00	Jennifer Leibenguth	Busy(Call)/A
140	11/09/2023 17:00	Lori Dement	Avail
141	11/09/2023 17:00	Lori Dement	W/U
142	11/09/2023 17:01	Lori Dement	Avail
143	11/09/2023 17:04	Lori Dement	Alrt(Call)/A
144	11/09/2023 17:04	Lori Dement	Busy(Call)/A
145	11/09/2023 17:05	Lori Dement	Avail
146	11/09/2023 17:05	Lori Dement	W/U
147	11/09/2023 17:05	Lori Dement	Avail
148	11/09/2023 17:06	Jennifer Leibenguth	Avail
149	11/09/2023 17:06	Jennifer Leibenguth	W/U
150	11/09/2023 17:24	Lori Dement	Avail
151	11/09/2023 17:25	Lori Dement	Alrt(Call)/A
152	11/09/2023 17:25	Lori Dement	Busy(Call)/A
153	11/09/2023 17:29	Jennifer Leibenguth	S/Out
154	11/09/2023 17:29	Jennifer Leibenguth	S/Out
155	11/09/2023 17:29	Jennifer Leibenguth	S/Out
156	11/09/2023 17:29	Jennifer Leibenguth	S/Out
157	11/09/2023 17:43	Lori Dement	Avail
158	11/09/2023 17:43	Lori Dement	Alrt(Call)/A
159	11/09/2023 17:43	Lori Dement	Busy(Call)/A
160	11/09/2023 17:47	Lori Dement	N/A
161	11/09/2023 17:50	David Powers	S/In
162	11/09/2023 17:50	David Powers	N/A
163	11/09/2023 17:50	David Powers	S/In
164	11/09/2023 17:50	David Powers	S/In
165	11/09/2023 17:51	David Powers	Avail
166	11/09/2023 17:51	David Powers	Alrt(Call)/A
167	11/09/2023 17:51	David Powers	Busy(Call)/A
168	11/09/2023 17:51	Lori Dement	S/Out
169	11/09/2023 17:51	Lori Dement	S/Out
170	11/09/2023 17:51	Lori Dement	S/Out
171	12/09/2023 09:01	Bonnie Bleier	S/In
172	12/09/2023 09:01	Bonnie Bleier	S/In
173	12/09/2023 09:01	Bonnie Bleier	S/In
174	12/09/2023 09:24	David Powers	S/In
175	12/09/2023 09:24	David Powers	N/A
176	12/09/2023 09:24	David Powers	S/In
177	12/09/2023 09:24	David Powers	S/In
178	12/09/2023 09:27	Jennifer Leibenguth	S/In
179	12/09/2023 09:27	Jennifer Leibenguth	N/A
180	12/09/2023 09:27	Jennifer Leibenguth	S/In
181	12/09/2023 09:49	Lori Dement	Busy(Call)/A
182	12/09/2023 09:50	David Powers	Alrt(Call)/A
183	12/09/2023 09:50	David Powers	Busy(Call)/A
184	12/09/2023 09:52	Bonnie Bleier	S/Out
185	12/09/2023 09:52	Bonnie Bleier	S/Out
186	12/09/2023 09:52	Bonnie Bleier	S/Out
187	12/09/2023 09:52	Bonnie Bleier	S/Out
188	12/09/2023 09:52	David Powers	Avail
189	12/09/2023 09:52	David Powers	W/U
190	12/09/2023 09:52	David Powers	Avail
191	12/09/2023 09:53	David Powers	Alrt(Call)/A
192	12/09/2023 09:53	David Powers	Busy(Call)/A
193	12/09/2023 09:53	David Powers	Avail
194	12/09/2023 09:54	Lori Dement	Avail
195	12/09/2023 09:58	David Powers	Alrt(Call)/A
196	12/09/2023 09:58	David Powers	Busy(Call)/A
197	12/09/2023 09:59	David Powers	Avail
198	12/09/2023 09:59	David Powers	W/U
199	12/09/2023 09:59	Lori Dement	Alrt(Call)/A
200	12/09/2023 09:59	Lori Dement	Busy(Call)/A
201	12/09/2023 09:59	David Powers	Avail
202	12/09/2023 09:59	David Powers	Alrt(Call)/A
203	12/09/2023 09:59	David Powers	Busy(Call)/A
204	12/09/2023 10:37	Lori Dement	Avail
205	12/09/2023 10:37	Lori Dement	Alrt(Call)/A
206	12/09/2023 10:37	Lori Dement	Busy(Call)/A
207	12/09/2023 10:41	Bonnie Bleier	S/In
208	12/09/2023 10:41	Bonnie Bleier	S/In
209	12/09/2023 10:41	Bonnie Bleier	Alrt(Call)/A
210	12/09/2023 10:41	Bonnie Bleier	Busy(Call)/A
211	12/09/2023 10:43	Lori Dement	Avail
212	12/09/2023 10:43	Lori Dement	W/U
213	12/09/2023 10:43	Lori Dement	Avail
214	12/09/2023 10:45	Lori Dement	Alrt(Call)/A
215	12/09/2023 10:45	Lori Dement	Busy(Call)/A
216	12/09/2023 10:45	Bonnie Bleier	Avail
217	12/09/2023 10:45	Bonnie Bleier	W/U
218	12/09/2023 10:45	Bonnie Bleier	Avail
219	12/09/2023 10:51	Lori Dement	Avail
220	12/09/2023 10:51	Lori Dement	W/U
221	12/09/2023 10:51	Lori Dement	Avail
222	12/09/2023 10:52	Lori Dement	Alrt(Call)/A
223	12/09/2023 10:52	Lori Dement	Busy(Call)/A
224	12/09/2023 10:54	Bonnie Bleier	Alrt(Call)/A
225	12/09/2023 11:00	Bonnie Bleier	Busy(Call)/A
226	12/09/2023 11:03	Lori Dement	N/A
227	12/09/2023 11:10	Bonnie Bleier	Avail
228	12/09/2023 11:10	Bonnie Bleier	W/U
229	12/09/2023 11:10	Bonnie Bleier	Avail
230	12/09/2023 11:51	David Powers	Avail
231	12/09/2023 11:51	David Powers	W/U
232	12/09/2023 11:51	David Powers	Avail
233	12/09/2023 11:52	Lori Dement	Alrt(Call)/A
234	12/09/2023 11:52	Lori Dement	Busy(Call)/A
235	12/09/2023 11:55	David Powers	Busy(Call)/A
236	12/09/2023 13:00	Bonnie Bleier	Avail
237	12/09/2023 13:00	Bonnie Bleier	W/U
238	12/09/2023 13:00	Bonnie Bleier	Avail
239	12/09/2023 13:00	Jennifer Leibenguth	N/A
240	12/09/2023 13:07	David Powers	Avail
241	12/09/2023 13:07	David Powers	W/U
242	12/09/2023 13:07	David Powers	Avail
243	12/09/2023 13:08	Lori Dement	Alrt(Call)/A
244	12/09/2023 13:09	Bonnie Bleier	Busy(Call)/A
245	12/09/2023 13:11	David Powers	Alrt(Call)/A
246	12/09/2023 13:11	David Powers	Busy(Call)/A
247	12/09/2023 13:14	Lori Dement	Avail
248	12/09/2023 13:16	Bonnie Bleier	Avail
249	12/09/2023 13:16	Lori Dement	N/A
250	12/09/2023 13:19	Lori Dement	Avail
251	12/09/2023 13:20	David Powers	Avail
252	12/09/2023 13:20	David Powers	W/U
253	12/09/2023 13:20	David Powers	Avail
254	12/09/2023 13:25	Lori Dement	Alrt(Call)/A
255	12/09/2023 13:26	Lori Dement	Busy(Call)/A
256	12/09/2023 13:28	Lori Dement	Avail
257	12/09/2023 13:37	David Powers	Avail
258	12/09/2023 13:42	Bonnie Bleier	Alrt(Call)/A
259	12/09/2023 13:42	Bonnie Bleier	Busy(Call)/A
260	12/09/2023 13:45	Lori Dement	N/A
261	12/09/2023 13:46	Bonnie Bleier	Avail
262	12/09/2023 13:46	Bonnie Bleier	W/U
263	12/09/2023 13:58	David Powers	Avail
264	12/09/2023 16:02	David Powers	Avail
265	12/09/2023 16:04	Marianne Peterson	S/Out
266	12/09/2023 16:04	Marianne Peterson	S/Out
267	12/09/2023 16:04	Marianne Peterson	S/Out
268	12/09/2023 16:04	Marianne Peterson	S/Out
269	12/09/2023 16:59	Bonnie Bleier	Avail
270	12/09/2023 16:59	Jennifer Leibenguth	S/Out
271	12/09/2023 16:59	Jennifer Leibenguth	S/Out
272	12/09/2023 16:59	Jennifer Leibenguth	S/Out
273	12/09/2023 16:59	Jennifer Leibenguth	S/Out
274	12/09/2023 17:29	Bonnie Bleier	Avail
275	12/09/2023 17:29	Bonnie Bleier	W/U
276	12/09/2023 17:29	Bonnie Bleier	Avail
277	12/09/2023 17:30	Lori Dement	S/Out
278	12/09/2023 17:32	David Powers	S/Out
279	12/09/2023 17:32	David Powers	S/Out
280	12/09/2023 17:32	David Powers	S/Out
281	12/09/2023 17:32	David Powers	S/Out
282	12/09/2023 17:32	David Powers	S/Out
283	12/09/2023 17:32	David Powers	S/Out
284	12/09/2023 17:45	Bonnie Bleier	Alrt(Call)/A
285	12/09/2023 18:37	Bonnie Bleier	S/Out
Sheet6

Cell Formulas
Range	Formula
E2:F11	E2	=UNIQUE(HSTACK(INT(A2:A285),B2:B285))
G2	G2	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)*(B$2:B$400=F2)*($C$2:$C$400=G$1)),1)
H2	H2	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)*(B$2:B$400=F2)*($C$2:$C$400=H$1)),1)
G3:G11	G3	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)*(B$2:B$400=F3)*($C$2:$C$400=G$1)),1)
H3:H11	H3	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)*(B$2:B$400=F3)*($C$2:$C$400=H$1)),1)
Dynamic array formulas.

 

[pitcrew]

Missed that part, try

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	Entry Time	Agent Name	State Chg				S/In	S/Out
2	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	Jennifer Leibenguth	11/09/2023 09:01	11/09/2023 17:29
3	11/09/2023 09:01	Jennifer Leibenguth	N/A		11/09/2023	Bonnie Bleier	#CALC!	11/09/2023 16:01
4	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	Lori Dement	11/09/2023 09:29	11/09/2023 17:51
5	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	David Powers	11/09/2023 09:53	11/09/2023 16:57
6	11/09/2023 09:01	Jennifer Leibenguth	S/In		11/09/2023	Marianne Peterson	#CALC!	11/09/2023 15:00
7	11/09/2023 09:01	Jennifer Leibenguth	S/In		12/09/2023	Bonnie Bleier	12/09/2023 09:01	12/09/2023 09:52
8	11/09/2023 09:01	Jennifer Leibenguth	S/In		12/09/2023	David Powers	12/09/2023 09:24	12/09/2023 17:32
9	11/09/2023 09:01	Jennifer Leibenguth	S/In		12/09/2023	Jennifer Leibenguth	12/09/2023 09:27	12/09/2023 16:59
10	11/09/2023 09:01	Jennifer Leibenguth	Avail		12/09/2023	Lori Dement	#CALC!	12/09/2023 17:30
11	11/09/2023 09:01	Jennifer Leibenguth	Alrt(Call)/A		12/09/2023	Marianne Peterson	#CALC!	12/09/2023 16:04
12	11/09/2023 09:01	Jennifer Leibenguth	Busy(Call)/A
13	11/09/2023 09:05	Bonnie Bleier	Busy(Call)/A
14	11/09/2023 09:11	Jennifer Leibenguth	Avail
15	11/09/2023 09:11	Jennifer Leibenguth	W/U
16	11/09/2023 09:11	Jennifer Leibenguth	Avail
17	11/09/2023 09:13	Bonnie Bleier	Avail
18	11/09/2023 09:14	Bonnie Bleier	Avail
19	11/09/2023 09:14	Jennifer Leibenguth	Alrt(Call)/A
20	11/09/2023 09:15	Jennifer Leibenguth	Busy(Call)/A
21	11/09/2023 09:18	Jennifer Leibenguth	Avail
22	11/09/2023 09:29	Lori Dement	S/In
23	11/09/2023 09:29	Lori Dement	N/A
24	11/09/2023 09:29	Lori Dement	S/In
25	11/09/2023 09:29	Lori Dement	S/In
26	11/09/2023 09:29	Lori Dement	S/In
27	11/09/2023 09:29	Lori Dement	S/In
28	11/09/2023 09:29	Lori Dement	S/In
29	11/09/2023 09:52	Bonnie Bleier	Avail
30	11/09/2023 09:53	David Powers	S/In
31	11/09/2023 09:53	David Powers	N/A
32	11/09/2023 09:53	David Powers	S/In
33	11/09/2023 09:53	David Powers	S/In
34	11/09/2023 09:53	David Powers	S/In
35	11/09/2023 09:53	David Powers	S/In
36	11/09/2023 09:53	David Powers	S/In
37	11/09/2023 09:54	Jennifer Leibenguth	N/A
38	11/09/2023 09:57	Bonnie Bleier	Alrt(Call)/A
39	11/09/2023 09:57	Bonnie Bleier	Busy(Call)/A
40	11/09/2023 09:57	Jennifer Leibenguth	Avail
41	11/09/2023 10:00	Bonnie Bleier	Avail
42	11/09/2023 10:00	Bonnie Bleier	W/U
43	11/09/2023 11:37	David Powers	Alrt(Call)/A
44	11/09/2023 11:37	Lori Dement	N/A
45	11/09/2023 11:37	David Powers	Busy(Call)/A
46	11/09/2023 11:45	David Powers	Avail
47	11/09/2023 11:45	David Powers	W/U
48	11/09/2023 11:55	Bonnie Bleier	W/U
49	11/09/2023 11:55	Bonnie Bleier	Avail
50	11/09/2023 15:00	Marianne Peterson	S/Out
51	11/09/2023 15:00	Marianne Peterson	S/Out
52	11/09/2023 15:00	Marianne Peterson	S/Out
53	11/09/2023 15:00	Marianne Peterson	S/Out
54	11/09/2023 15:00	Marianne Peterson	S/Out
55	11/09/2023 15:00	Marianne Peterson	S/Out
56	11/09/2023 15:00	Marianne Peterson	S/Out
57	11/09/2023 15:05	David Powers	N/A
58	11/09/2023 15:06	David Powers	Avail
59	11/09/2023 15:12	Bonnie Bleier	Avail
60	11/09/2023 15:12	Bonnie Bleier	W/U
61	11/09/2023 15:12	Bonnie Bleier	Avail
62	11/09/2023 15:14	Bonnie Bleier	Alrt(Call)/A
63	11/09/2023 15:14	Bonnie Bleier	Busy(Call)/A
64	11/09/2023 15:15	Jennifer Leibenguth	Avail
65	11/09/2023 15:15	Jennifer Leibenguth	W/U
66	11/09/2023 15:15	David Powers	Avail
67	11/09/2023 15:15	David Powers	W/U
68	11/09/2023 15:15	Jennifer Leibenguth	Avail
69	11/09/2023 15:15	David Powers	Avail
70	11/09/2023 15:17	Jennifer Leibenguth	N/A
71	11/09/2023 15:19	Bonnie Bleier	Avail
72	11/09/2023 15:20	Bonnie Bleier	Alrt(Call)/A
73	11/09/2023 15:21	Bonnie Bleier	Busy(Call)/A
74	11/09/2023 15:21	Jennifer Leibenguth	Avail
75	11/09/2023 15:21	Bonnie Bleier	Avail
76	11/09/2023 15:32	Jennifer Leibenguth	N/A
77	11/09/2023 15:32	Lori Dement	Alrt(Call)/A
78	11/09/2023 15:32	Lori Dement	Busy(Call)/A
79	11/09/2023 15:37	Lori Dement	Avail
80	11/09/2023 15:37	Lori Dement	W/U
81	11/09/2023 15:38	Lori Dement	Avail
82	11/09/2023 15:46	Bonnie Bleier	W/U
83	11/09/2023 15:46	Bonnie Bleier	Avail
84	11/09/2023 15:48	Lori Dement	Avail
85	11/09/2023 15:48	Lori Dement	W/U
86	11/09/2023 15:48	Lori Dement	Avail
87	11/09/2023 15:51	Bonnie Bleier	Alrt(Call)/A
88	11/09/2023 15:51	Bonnie Bleier	Busy(Call)/A
89	11/09/2023 15:57	Lori Dement	N/A
90	11/09/2023 15:59	Bonnie Bleier	N/A
91	11/09/2023 16:01	Bonnie Bleier	S/Out
92	11/09/2023 16:01	Bonnie Bleier	S/Out
93	11/09/2023 16:01	Bonnie Bleier	S/Out
94	11/09/2023 16:01	Bonnie Bleier	S/Out
95	11/09/2023 16:01	Bonnie Bleier	S/Out
96	11/09/2023 16:01	Bonnie Bleier	S/Out
97	11/09/2023 16:03	David Powers	Avail
98	11/09/2023 16:07	David Powers	Alrt(Call)/A
99	11/09/2023 16:07	David Powers	Busy(Call)/A
100	11/09/2023 16:10	Jennifer Leibenguth	Avail
101	11/09/2023 16:13	David Powers	Avail
102	11/09/2023 16:13	David Powers	W/U
103	11/09/2023 16:13	David Powers	Avail
104	11/09/2023 16:17	Jennifer Leibenguth	Alrt(Call)/A
105	11/09/2023 16:17	Jennifer Leibenguth	Busy(Call)/A
106	11/09/2023 16:20	David Powers	Alrt(Call)/A
107	11/09/2023 16:20	David Powers	Busy(Call)/A
108	11/09/2023 16:23	Jennifer Leibenguth	Avail
109	11/09/2023 16:23	Jennifer Leibenguth	W/U
110	11/09/2023 16:23	Jennifer Leibenguth	Avail
111	11/09/2023 16:33	Jennifer Leibenguth	Alrt(Call)/A
112	11/09/2023 16:33	Jennifer Leibenguth	Busy(Call)/A
113	11/09/2023 16:34	David Powers	Avail
114	11/09/2023 16:34	David Powers	W/U
115	11/09/2023 16:34	David Powers	Avail
116	11/09/2023 16:36	David Powers	Alrt(Call)/A
117	11/09/2023 16:36	Jennifer Leibenguth	Avail
118	11/09/2023 16:36	Jennifer Leibenguth	W/U
119	11/09/2023 16:36	David Powers	Busy(Call)/A
120	11/09/2023 16:37	Jennifer Leibenguth	Avail
121	11/09/2023 16:42	David Powers	Avail
122	11/09/2023 16:42	David Powers	W/U
123	11/09/2023 16:42	David Powers	Avail
124	11/09/2023 16:46	Lori Dement	Avail
125	11/09/2023 16:52	Lori Dement	Alrt(Call)/A
126	11/09/2023 16:52	Lori Dement	Busy(Call)/A
127	11/09/2023 16:52	David Powers	N/A
128	11/09/2023 16:53	Jennifer Leibenguth	Alrt(Call)/A
129	11/09/2023 16:53	Jennifer Leibenguth	Busy(Call)/A
130	11/09/2023 16:57	David Powers	S/Out
131	11/09/2023 16:57	David Powers	S/Out
132	11/09/2023 16:57	David Powers	S/Out
133	11/09/2023 16:57	David Powers	S/Out
134	11/09/2023 16:57	David Powers	S/Out
135	11/09/2023 16:57	David Powers	S/Out
136	11/09/2023 16:57	Jennifer Leibenguth	Avail
137	11/09/2023 16:57	Jennifer Leibenguth	W/U
138	11/09/2023 17:00	Jennifer Leibenguth	Alrt(Call)/A
139	11/09/2023 17:00	Jennifer Leibenguth	Busy(Call)/A
140	11/09/2023 17:00	Lori Dement	Avail
141	11/09/2023 17:00	Lori Dement	W/U
142	11/09/2023 17:01	Lori Dement	Avail
143	11/09/2023 17:04	Lori Dement	Alrt(Call)/A
144	11/09/2023 17:04	Lori Dement	Busy(Call)/A
145	11/09/2023 17:05	Lori Dement	Avail
146	11/09/2023 17:05	Lori Dement	W/U
147	11/09/2023 17:05	Lori Dement	Avail
148	11/09/2023 17:06	Jennifer Leibenguth	Avail
149	11/09/2023 17:06	Jennifer Leibenguth	W/U
150	11/09/2023 17:24	Lori Dement	Avail
151	11/09/2023 17:25	Lori Dement	Alrt(Call)/A
152	11/09/2023 17:25	Lori Dement	Busy(Call)/A
153	11/09/2023 17:29	Jennifer Leibenguth	S/Out
154	11/09/2023 17:29	Jennifer Leibenguth	S/Out
155	11/09/2023 17:29	Jennifer Leibenguth	S/Out
156	11/09/2023 17:29	Jennifer Leibenguth	S/Out
157	11/09/2023 17:43	Lori Dement	Avail
158	11/09/2023 17:43	Lori Dement	Alrt(Call)/A
159	11/09/2023 17:43	Lori Dement	Busy(Call)/A
160	11/09/2023 17:47	Lori Dement	N/A
161	11/09/2023 17:50	David Powers	S/In
162	11/09/2023 17:50	David Powers	N/A
163	11/09/2023 17:50	David Powers	S/In
164	11/09/2023 17:50	David Powers	S/In
165	11/09/2023 17:51	David Powers	Avail
166	11/09/2023 17:51	David Powers	Alrt(Call)/A
167	11/09/2023 17:51	David Powers	Busy(Call)/A
168	11/09/2023 17:51	Lori Dement	S/Out
169	11/09/2023 17:51	Lori Dement	S/Out
170	11/09/2023 17:51	Lori Dement	S/Out
171	12/09/2023 09:01	Bonnie Bleier	S/In
172	12/09/2023 09:01	Bonnie Bleier	S/In
173	12/09/2023 09:01	Bonnie Bleier	S/In
174	12/09/2023 09:24	David Powers	S/In
175	12/09/2023 09:24	David Powers	N/A
176	12/09/2023 09:24	David Powers	S/In
177	12/09/2023 09:24	David Powers	S/In
178	12/09/2023 09:27	Jennifer Leibenguth	S/In
179	12/09/2023 09:27	Jennifer Leibenguth	N/A
180	12/09/2023 09:27	Jennifer Leibenguth	S/In
181	12/09/2023 09:49	Lori Dement	Busy(Call)/A
182	12/09/2023 09:50	David Powers	Alrt(Call)/A
183	12/09/2023 09:50	David Powers	Busy(Call)/A
184	12/09/2023 09:52	Bonnie Bleier	S/Out
185	12/09/2023 09:52	Bonnie Bleier	S/Out
186	12/09/2023 09:52	Bonnie Bleier	S/Out
187	12/09/2023 09:52	Bonnie Bleier	S/Out
188	12/09/2023 09:52	David Powers	Avail
189	12/09/2023 09:52	David Powers	W/U
190	12/09/2023 09:52	David Powers	Avail
191	12/09/2023 09:53	David Powers	Alrt(Call)/A
192	12/09/2023 09:53	David Powers	Busy(Call)/A
193	12/09/2023 09:53	David Powers	Avail
194	12/09/2023 09:54	Lori Dement	Avail
195	12/09/2023 09:58	David Powers	Alrt(Call)/A
196	12/09/2023 09:58	David Powers	Busy(Call)/A
197	12/09/2023 09:59	David Powers	Avail
198	12/09/2023 09:59	David Powers	W/U
199	12/09/2023 09:59	Lori Dement	Alrt(Call)/A
200	12/09/2023 09:59	Lori Dement	Busy(Call)/A
201	12/09/2023 09:59	David Powers	Avail
202	12/09/2023 09:59	David Powers	Alrt(Call)/A
203	12/09/2023 09:59	David Powers	Busy(Call)/A
204	12/09/2023 10:37	Lori Dement	Avail
205	12/09/2023 10:37	Lori Dement	Alrt(Call)/A
206	12/09/2023 10:37	Lori Dement	Busy(Call)/A
207	12/09/2023 10:41	Bonnie Bleier	S/In
208	12/09/2023 10:41	Bonnie Bleier	S/In
209	12/09/2023 10:41	Bonnie Bleier	Alrt(Call)/A
210	12/09/2023 10:41	Bonnie Bleier	Busy(Call)/A
211	12/09/2023 10:43	Lori Dement	Avail
212	12/09/2023 10:43	Lori Dement	W/U
213	12/09/2023 10:43	Lori Dement	Avail
214	12/09/2023 10:45	Lori Dement	Alrt(Call)/A
215	12/09/2023 10:45	Lori Dement	Busy(Call)/A
216	12/09/2023 10:45	Bonnie Bleier	Avail
217	12/09/2023 10:45	Bonnie Bleier	W/U
218	12/09/2023 10:45	Bonnie Bleier	Avail
219	12/09/2023 10:51	Lori Dement	Avail
220	12/09/2023 10:51	Lori Dement	W/U
221	12/09/2023 10:51	Lori Dement	Avail
222	12/09/2023 10:52	Lori Dement	Alrt(Call)/A
223	12/09/2023 10:52	Lori Dement	Busy(Call)/A
224	12/09/2023 10:54	Bonnie Bleier	Alrt(Call)/A
225	12/09/2023 11:00	Bonnie Bleier	Busy(Call)/A
226	12/09/2023 11:03	Lori Dement	N/A
227	12/09/2023 11:10	Bonnie Bleier	Avail
228	12/09/2023 11:10	Bonnie Bleier	W/U
229	12/09/2023 11:10	Bonnie Bleier	Avail
230	12/09/2023 11:51	David Powers	Avail
231	12/09/2023 11:51	David Powers	W/U
232	12/09/2023 11:51	David Powers	Avail
233	12/09/2023 11:52	Lori Dement	Alrt(Call)/A
234	12/09/2023 11:52	Lori Dement	Busy(Call)/A
235	12/09/2023 11:55	David Powers	Busy(Call)/A
236	12/09/2023 13:00	Bonnie Bleier	Avail
237	12/09/2023 13:00	Bonnie Bleier	W/U
238	12/09/2023 13:00	Bonnie Bleier	Avail
239	12/09/2023 13:00	Jennifer Leibenguth	N/A
240	12/09/2023 13:07	David Powers	Avail
241	12/09/2023 13:07	David Powers	W/U
242	12/09/2023 13:07	David Powers	Avail
243	12/09/2023 13:08	Lori Dement	Alrt(Call)/A
244	12/09/2023 13:09	Bonnie Bleier	Busy(Call)/A
245	12/09/2023 13:11	David Powers	Alrt(Call)/A
246	12/09/2023 13:11	David Powers	Busy(Call)/A
247	12/09/2023 13:14	Lori Dement	Avail
248	12/09/2023 13:16	Bonnie Bleier	Avail
249	12/09/2023 13:16	Lori Dement	N/A
250	12/09/2023 13:19	Lori Dement	Avail
251	12/09/2023 13:20	David Powers	Avail
252	12/09/2023 13:20	David Powers	W/U
253	12/09/2023 13:20	David Powers	Avail
254	12/09/2023 13:25	Lori Dement	Alrt(Call)/A
255	12/09/2023 13:26	Lori Dement	Busy(Call)/A
256	12/09/2023 13:28	Lori Dement	Avail
257	12/09/2023 13:37	David Powers	Avail
258	12/09/2023 13:42	Bonnie Bleier	Alrt(Call)/A
259	12/09/2023 13:42	Bonnie Bleier	Busy(Call)/A
260	12/09/2023 13:45	Lori Dement	N/A
261	12/09/2023 13:46	Bonnie Bleier	Avail
262	12/09/2023 13:46	Bonnie Bleier	W/U
263	12/09/2023 13:58	David Powers	Avail
264	12/09/2023 16:02	David Powers	Avail
265	12/09/2023 16:04	Marianne Peterson	S/Out
266	12/09/2023 16:04	Marianne Peterson	S/Out
267	12/09/2023 16:04	Marianne Peterson	S/Out
268	12/09/2023 16:04	Marianne Peterson	S/Out
269	12/09/2023 16:59	Bonnie Bleier	Avail
270	12/09/2023 16:59	Jennifer Leibenguth	S/Out
271	12/09/2023 16:59	Jennifer Leibenguth	S/Out
272	12/09/2023 16:59	Jennifer Leibenguth	S/Out
273	12/09/2023 16:59	Jennifer Leibenguth	S/Out
274	12/09/2023 17:29	Bonnie Bleier	Avail
275	12/09/2023 17:29	Bonnie Bleier	W/U
276	12/09/2023 17:29	Bonnie Bleier	Avail
277	12/09/2023 17:30	Lori Dement	S/Out
278	12/09/2023 17:32	David Powers	S/Out
279	12/09/2023 17:32	David Powers	S/Out
280	12/09/2023 17:32	David Powers	S/Out
281	12/09/2023 17:32	David Powers	S/Out
282	12/09/2023 17:32	David Powers	S/Out
283	12/09/2023 17:32	David Powers	S/Out
284	12/09/2023 17:45	Bonnie Bleier	Alrt(Call)/A
285	12/09/2023 18:37	Bonnie Bleier	S/Out
Sheet6

Cell Formulas
Range	Formula
E2:F11	E2	=UNIQUE(HSTACK(INT(A2:A285),B2:B285))
G2	G2	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)*(B$2:B$400=F2)*($C$2:$C$400=G$1)),1)
H2	H2	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=E2)*(B$2:B$400=F2)*($C$2:$C$400=H$1)),1)
G3:G11	G3	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)*(B$2:B$400=F3)*($C$2:$C$400=G$1)),1)
H3:H11	H3	=TAKE(FILTER($A$2:$A$400,(INT(A$2:A$400)=$E3)*(B$2:B$400=F3)*($C$2:$C$400=H$1)),1)
Dynamic array formulas.

That worked perfectly, thanks you so much for your help! I hope you have a great weekend.

 

[Fluff]

You're welcome & thanks for the feedback.