Number of unique daily clock-ins

[marshak]

Hi I would love your expertise once again.

I have a table that shows clock-ins and dates. I need to show the number of unique daily clock-ins for January 31, January 30, January 29, etc.

I did a pivot able, but it just counts the total number of clock-ins for each date -- I need a unique values count. For example, in my table, Person ID 14957 may show up in 3 rows on the same date -- pivot table will mark that as 3 (count of entries) however he should only be counted as 1 for that date. Hope I haven't confused you.

Please help! Thanks in advance for your time.

demo file.xlsx
	A	B
1	Person ID	Node Date/Time
2	_5231	01/31/2019 23:59:20
3	_5231	01/31/2019 23:59:15
4	15339	01/31/2019 23:59:07
5	14957	01/31/2019 23:58:53
6	14957	01/31/2019 23:58:29
7	13893	01/31/2019 23:52:54
8	15098	01/31/2019 23:52:41
9	13898	01/31/2019 23:52:37
10	_4177	01/31/2019 23:52:33
11	_95	01/31/2019 23:52:16
12	14826	01/31/2019 23:50:15
13	14073	01/30/2019 7:23:43
14	15416	01/30/2019 7:22:57
15	14311	01/30/2019 7:22:52
16		01/29/2019 22:07:26
17		01/29/2019 22:07:24
18	13626	01/29/2019 22:06:16
19	15330	01/29/2019 22:05:58
20	12849	01/28/2019 9:09:38
21		01/28/2019 9:09:35
22	_48	01/28/2019 9:09:29
23		01/28/2019 9:09:25
24	_379	01/28/2019 9:09:25
25	13633	01/28/2019 9:09:24
26		01/28/2019 9:09:20
27	14542	01/28/2019 9:09:11
28	14334	01/28/2019 9:09:11
29	13633	01/28/2019 9:09:04
30	P04325	01/28/2019 9:09:01
31	14357	01/28/2019 9:09:00
32	14159	01/28/2019 9:08:54
33	15222	01/28/2019 9:08:43
34	P04325	01/28/2019 9:08:39
35	14786	01/28/2019 9:08:37
36	15222	01/28/2019 9:08:25
37	13624	01/28/2019 9:08:22
38	11478	01/28/2019 9:08:21
39	12255	01/28/2019 9:08:15
40		01/28/2019 9:08:04
41	11238	01/28/2019 9:08:00
42	12255	01/28/2019 9:07:53
43	11262	01/28/2019 9:07:50
44	14942	01/28/2019 9:07:47
45	15215	01/28/2019 9:07:43
46	13275	01/28/2019 9:07:38
47	13456	01/28/2019 9:07:33
48	11347	01/28/2019 9:07:31
49		01/28/2019 9:07:30
50	14102	01/28/2019 9:07:27
51		01/28/2019 9:07:22
52	13358	01/28/2019 9:07:10
53	14289	01/28/2019 9:07:07
54	14102	01/28/2019 9:07:06
55	13555	01/28/2019 9:06:58
56	14289	01/28/2019 9:06:48
57	11405	01/28/2019 9:06:42
58	15037	01/28/2019 9:06:38
59	12757	01/28/2019 9:06:37
60		01/28/2019 9:06:35
61	11375	01/28/2019 9:06:24
62	12691	01/28/2019 9:06:23
63	11852	01/28/2019 9:06:17
64	10199	01/28/2019 9:06:09
65	14683	01/28/2019 9:05:58
66	14613	01/28/2019 9:05:55
67		01/28/2019 9:05:50
68	12790	01/28/2019 9:05:42
69		01/28/2019 9:05:27
70	10706	01/28/2019 9:05:28
71	14215	01/28/2019 9:05:27
72		01/28/2019 9:05:27
73		01/28/2019 9:05:25
74	10014	01/28/2019 9:05:17
75		01/28/2019 9:05:16
76	13029	01/28/2019 9:05:16
77	13416	01/28/2019 9:05:03
78	13836	01/28/2019 9:05:02
79		01/28/2019 9:04:55
80		01/28/2019 9:04:53
81		01/28/2019 9:04:52
82	14844	01/28/2019 9:04:47
83	10770	01/28/2019 9:04:47
84	10201	01/28/2019 9:04:33
85	13878	01/28/2019 9:04:30
86	_5324	01/28/2019 9:04:24
87	_5324	01/28/2019 9:04:22
88	11820	01/28/2019 9:04:21
89	11027	01/28/2019 9:04:12
90		01/28/2019 9:04:07
91	15005	01/28/2019 9:04:05
92		01/28/2019 9:04:05
93		01/28/2019 9:04:03
94	11981	01/28/2019 9:03:52
95	13611	01/28/2019 9:03:51
96	11027	01/28/2019 9:03:51
97	15196	01/28/2019 9:03:50
98	15255	01/28/2019 9:03:50
99		01/28/2019 9:03:44
100	13776	01/28/2019 9:03:43
101		01/28/2019 9:03:42
102	14726	01/28/2019 9:03:29
103	12834	01/28/2019 9:03:16
104	10804	01/28/2019 9:02:55
105	14074	01/28/2019 9:02:45
106	12794	01/28/2019 9:02:39
107	10856	01/28/2019 9:02:32
108	12691	01/28/2019 9:02:21
109	14074	01/28/2019 9:02:19
110		01/28/2019 9:02:15
111	13155	01/28/2019 9:02:13
112		01/28/2019 9:02:06
113		01/28/2019 9:02:00
114	15055	01/28/2019 9:01:56
115	14889	01/28/2019 9:01:52
116	15280	01/28/2019 9:01:45
117	14146	01/28/2019 9:01:31
118	13757	01/28/2019 9:01:30
119	13362	01/28/2019 9:01:23
120	10543	01/28/2019 9:01:23
121	10543	01/28/2019 9:01:03
122	14541	01/28/2019 9:00:58
123	14757	01/28/2019 9:00:53
124	12791	01/28/2019 9:00:50
125	_DK2877	01/28/2019 9:00:49
126	10253	01/28/2019 9:00:49
127	10464	01/28/2019 9:00:44
128	12478	01/28/2019 9:00:37
129	_292	01/28/2019 9:00:36
130	12462	01/28/2019 9:00:35
131	13805	01/28/2019 9:00:33
132	14827	01/28/2019 9:00:30
133	10464	01/28/2019 9:00:29
134	12845	01/28/2019 5:47:37
135		01/28/2019 5:47:34
136	11708	01/28/2019 5:47:25
137	11708	01/28/2019 5:47:05
138	_755	01/28/2019 5:46:39
139	11585	01/28/2019 5:46:22
140		01/28/2019 5:46:05
141	11585	01/28/2019 5:45:51
142	11316	01/28/2019 5:45:33
143	_755	01/28/2019 5:44:32
144		01/28/2019 5:44:03
145	15167	01/28/2019 5:44:01
146	11294	01/28/2019 5:43:53
147	11316	01/28/2019 5:42:35
148	11294	01/28/2019 5:42:20
149	11787	01/28/2019 5:41:29
150	11787	01/28/2019 5:41:14
151	_GG968	01/27/2019 22:43:15
152	_GG968	01/27/2019 22:42:58
153	_GG968	01/27/2019 22:42:49
154	14312	01/27/2019 22:42:33
155	_376	01/26/2019 10:24:11
156	_4922	01/26/2019 10:23:46
157	14824	01/26/2019 10:21:32
158	_376	01/26/2019 10:17:36
159	15226	01/26/2019 10:17:33
160	_376	01/26/2019 10:17:06
161	14307	01/26/2019 10:16:19
162	_FF3029	01/26/2019 10:14:01
163	11824	01/26/2019 10:13:09
164	11824	01/26/2019 10:12:51
165	14307	01/26/2019 10:11:39
166	15226	01/26/2019 10:11:30
167	14307	01/26/2019 10:09:24
168	14307	01/26/2019 10:08:55
169	11824	01/26/2019 10:07:48
170	11824	01/26/2019 10:07:34
171	11275	01/26/2019 10:06:14
172	11275	01/26/2019 10:05:51
173		01/26/2019 10:05:51
174		01/26/2019 10:03:10
175	_670	01/26/2019 10:02:57
176	15177	01/26/2019 9:51:51
177	12892	01/26/2019 9:48:21
178	12892	01/26/2019 9:48:15
179	_755	01/26/2019 9:48:11
180	10236	01/25/2019 16:15:07
181	11731	01/25/2019 16:15:05
182	15159	01/25/2019 16:15:03
183	13083	01/25/2019 16:15:02
184	15332	01/25/2019 16:15:01
185	11110	01/25/2019 16:14:56
186	10874	01/25/2019 16:14:55
187	14663	01/25/2019 16:14:52
188	11908	01/25/2019 16:14:52
189	14003	01/25/2019 16:14:51
190	13555	01/25/2019 16:14:41
191	10908	01/25/2019 16:14:36
192		01/25/2019 16:14:34
193	12579	01/25/2019 16:14:29
194		01/25/2019 16:14:29
195	14970	01/25/2019 16:14:24
196	14659	01/25/2019 16:14:23
197	15090	01/25/2019 16:14:21
198	14812	01/25/2019 16:14:19
199	10978	01/25/2019 16:14:17
200	12523	01/25/2019 16:14:15
201	13396	01/25/2019 16:14:15
202	14781	01/25/2019 16:14:14
203	15041	01/25/2019 16:14:13
204	10756	01/25/2019 16:14:13
205	10908	01/25/2019 16:14:11
206	13783	01/25/2019 16:14:09
207	14726	01/25/2019 16:14:09
208	12255	01/25/2019 16:14:07
209	11328	01/25/2019 16:14:06
210	_218	01/25/2019 16:14:06
211	13817	01/25/2019 16:13:39
212	10887	01/25/2019 16:13:34
213	12254	01/25/2019 16:13:29
214	12135	01/25/2019 16:13:27
215	10966	01/25/2019 16:13:25
216	14332	01/25/2019 16:13:18
217	13155	01/25/2019 16:13:15
218	14038	01/25/2019 16:13:11
219	10908	01/25/2019 16:13:07
220	13045	01/25/2019 16:13:06
221	13227	01/25/2019 16:12:58
222	14495	01/25/2019 16:12:52
223	14230	01/25/2019 16:12:45
224	12434	01/25/2019 16:12:43
225	14195	01/25/2019 16:12:36
226	14734	01/24/2019 22:45:53
227	14237	01/24/2019 22:45:48
228		01/24/2019 22:45:48
229		01/24/2019 22:45:38
230	14734	01/24/2019 22:45:20
231	15098	01/24/2019 22:45:13
232		01/24/2019 22:44:40
233		01/24/2019 22:44:30
234	14733	01/24/2019 22:44:04
235	14733	01/24/2019 22:43:43
236	14734	01/24/2019 22:43:24
237	12867	01/24/2019 22:43:00
238	14328	01/24/2019 22:42:57
239	15104	01/24/2019 22:42:54
240	14096	01/24/2019 22:41:36
241	14328	01/24/2019 22:41:29
242	14826	01/24/2019 22:41:14
243	13906	01/24/2019 22:40:15
244	15333	01/24/2019 22:39:51
245	13893	01/24/2019 22:39:19
246	13893	01/24/2019 22:38:58
247	15341	01/24/2019 22:38:01
248	14096	01/24/2019 22:34:51
249	15328	01/24/2019 22:34:10
250	15328	01/24/2019 22:33:50
251	14309	01/24/2019 22:31:17
252	_4007	01/24/2019 22:31:11
253	15324	01/24/2019 22:29:24
254	14198	01/24/2019 22:29:17
255	14826	01/23/2019 18:44:26
256	15365	01/23/2019 18:44:21
257	10999	01/23/2019 18:44:11
258	14140	01/23/2019 18:44:00
259	14658	01/23/2019 18:43:53
260		01/23/2019 18:43:43
261	14991	01/23/2019 18:42:57
262	14467	01/23/2019 18:42:17
263		01/23/2019 18:41:58
264	13194	01/23/2019 18:41:54
265	10334	01/23/2019 18:41:24
266	13259	01/23/2019 18:41:15
267	10876	01/23/2019 18:41:09
268	13396	01/23/2019 18:41:08
269		01/23/2019 18:41:05
270		01/23/2019 18:40:53
271		01/23/2019 18:40:45
272		01/23/2019 18:40:44
273	14269	01/23/2019 18:40:43
274		01/23/2019 18:40:39
275	15388	01/23/2019 18:40:26
276	14511	01/23/2019 18:39:57
277		01/23/2019 18:39:46
278	14338	01/23/2019 18:39:33
279		01/23/2019 18:39:33
280		01/23/2019 18:39:16
281	13893	01/23/2019 18:39:12
282		01/23/2019 18:38:49
283		01/23/2019 18:38:40
284	13056	01/23/2019 18:38:32
285	15341	01/23/2019 18:38:26
286	15100	01/23/2019 18:38:04
287	13549	01/23/2019 18:37:43
288	10322	01/23/2019 18:36:59
289	14095	01/23/2019 18:36:57
290	14099	01/23/2019 18:36:52
291	10820	01/23/2019 18:36:22
292		01/23/2019 18:36:10
293	14175	01/23/2019 18:36:06
294		01/23/2019 18:35:58
295	10151	01/23/2019 18:35:49
296		01/23/2019 18:35:41
297	14654	01/23/2019 18:35:38
298	14038	01/23/2019 18:35:37
299	13397	01/23/2019 18:35:22
300	12945	01/23/2019 18:35:22
301	14269	01/23/2019 18:35:15
302		01/23/2019 18:35:07
303		01/23/2019 18:35:07
304		01/23/2019 18:35:00
305		01/23/2019 18:34:59
306	12544	01/23/2019 18:34:54
307	13999	01/23/2019 18:34:44
308	11268	01/23/2019 18:34:20
309	14552	01/23/2019 18:34:19
310		01/23/2019 18:34:12
311	14908	01/23/2019 18:33:56
312	14792	01/23/2019 18:33:38
313	13194	01/23/2019 18:33:33
314	14269	01/23/2019 18:33:26
315	13095	01/23/2019 18:33:20
316	10907	01/23/2019 18:33:18
317	14864	01/23/2019 18:33:04
318	15407	01/23/2019 18:32:37
319	15406	01/23/2019 18:32:37
320	11991	01/23/2019 18:32:33
321	13844	01/23/2019 18:32:29
322	15356	01/23/2019 18:32:01
323	10459	01/23/2019 18:31:59
324	11897	01/23/2019 18:31:54
325		01/23/2019 18:31:15
326		01/23/2019 18:31:15
327	13056	01/23/2019 18:31:15
328		01/23/2019 18:31:15
329	14611	01/23/2019 18:31:15
330	13508	01/23/2019 18:31:08
331		01/23/2019 18:30:50
332		01/23/2019 18:30:45
333	10662	01/23/2019 18:30:44
334	14750	01/23/2019 18:30:37
335	10175	01/23/2019 18:30:19
336	13788	01/23/2019 18:29:53
337	15100	01/23/2019 18:29:32
338	12571	01/23/2019 18:29:31
339	13095	01/23/2019 18:29:16
340	12552	01/23/2019 18:29:12
341		01/23/2019 18:28:59
342	10756	01/23/2019 18:28:54
343	15329	01/23/2019 18:28:46
344	14063	01/23/2019 18:28:16
345	14610	01/23/2019 18:28:09
346		01/23/2019 18:28:06
347		01/23/2019 18:27:50
348	13095	01/23/2019 18:27:49
349		01/23/2019 18:27:38
350	14595	01/23/2019 18:27:24
351	15243	01/23/2019 18:27:01
352	13487	01/23/2019 18:26:59
353	11991	01/23/2019 18:26:57
354	14864	01/23/2019 18:26:14
355	13806	01/23/2019 18:26:08
356		01/23/2019 18:25:55
357		01/23/2019 18:25:32
358	15329	01/23/2019 18:25:26
359	15356	01/23/2019 18:25:19
360	12995	01/23/2019 18:24:32
361	11835	01/23/2019 18:24:20
362	14214	01/23/2019 18:23:59
363	12128	01/23/2019 18:23:48
364	14750	01/23/2019 18:23:20
365	10926	01/23/2019 18:23:12
366	13823	01/23/2019 18:23:09
367	13893	01/23/2019 18:23:01
368		01/23/2019 18:22:53
369		01/23/2019 18:22:40
370	15388	01/23/2019 18:22:35
371		01/23/2019 18:22:33
372		01/23/2019 18:22:31
373	15104	01/23/2019 18:22:08
374	13823	01/23/2019 18:21:54
375	15328	01/23/2019 18:21:44
376		01/23/2019 18:21:37
377		01/23/2019 18:21:37
378	14954	01/23/2019 18:21:31
379	13823	01/23/2019 18:21:26
380		01/23/2019 18:21:12
381		01/23/2019 18:21:06
382	15100	01/23/2019 18:20:54
383		01/23/2019 18:20:32
384	13487	01/23/2019 18:20:29
385	14397	01/23/2019 18:20:27
386		01/23/2019 18:20:24
387		01/23/2019 18:20:23
388		01/23/2019 18:20:20
389	15330	01/23/2019 18:20:20
390	12308	01/23/2019 18:20:19
391	13487	01/23/2019 18:20:14
392	11991	01/23/2019 18:19:47
393	12571	01/23/2019 18:19:42
394	15104	01/23/2019 18:19:27
395	10495	01/23/2019 18:19:05
396		01/23/2019 18:18:58
397		01/23/2019 18:18:51
398	13893	01/23/2019 18:18:43
399	13318	01/23/2019 18:18:39
400	11991	01/23/2019 18:18:26
401	10358	01/23/2019 18:18:09
402		01/23/2019 18:18:00
403		01/23/2019 18:18:00
404	10316	01/23/2019 18:17:54
405		01/23/2019 18:17:52
406		01/23/2019 18:17:51
407	13508	01/23/2019 18:17:45
408	12868	01/23/2019 18:16:49
409		01/23/2019 18:16:16
410		01/23/2019 18:16:16
411		01/23/2019 18:15:48
412		01/23/2019 18:15:43
413	14979	01/23/2019 18:15:37
414	15098	01/23/2019 18:15:17
415	10175	01/23/2019 18:15:04
416	11947	01/23/2019 18:14:49
417	10632	01/23/2019 18:14:29
418	10632	01/23/2019 18:14:03
419	15333	01/23/2019 18:14:01
420		01/23/2019 18:13:55
421		01/23/2019 18:13:55
422	12910	01/23/2019 18:13:50
423	14896	01/23/2019 18:13:48
424	12692	01/23/2019 18:13:38
425	13906	01/23/2019 18:13:29
426		01/23/2019 18:13:00
427	13893	01/23/2019 18:12:55
428	14932	01/23/2019 18:12:53
429		01/23/2019 18:12:51
430	14376	01/23/2019 18:11:30
431	14385	01/23/2019 18:11:24
432	10917	01/23/2019 18:10:41
433	12305	01/23/2019 18:10:40
434	15263	01/23/2019 18:10:36
435	13344	01/23/2019 18:10:22
436	10904	01/23/2019 18:10:20
437	11762	01/23/2019 18:10:07
438	13318	01/23/2019 18:09:45
439	15274	01/23/2019 18:09:32
440		01/23/2019 18:09:08
441	14896	01/23/2019 18:08:54
442	11762	01/23/2019 18:08:38
443	11835	01/23/2019 18:08:34
444		01/23/2019 18:08:20
445	11762	01/23/2019 18:08:18
446		01/23/2019 18:08:12
447	11520	01/23/2019 18:08:09
448	_465	01/23/2019 18:08:09
449	13259	01/23/2019 18:08:02
450	11520	01/23/2019 18:08:02
451	15019	01/23/2019 18:07:57
452	14088	01/23/2019 18:07:49
453	13893	01/23/2019 18:07:49
454	_668	01/23/2019 18:07:48
455	14932	01/23/2019 18:07:38
456	_378	01/23/2019 18:07:36
457	11519	01/23/2019 18:07:32
458	_668	01/23/2019 18:07:27
459		01/23/2019 18:07:16
460	13893	01/23/2019 18:07:04
461	10872	01/23/2019 18:06:59
462		01/23/2019 18:06:56
463	_668	01/23/2019 18:06:43
464	12536	01/23/2019 18:06:25
465	15329	01/23/2019 18:06:25
466	_668	01/23/2019 18:06:24
467	14095	01/23/2019 18:05:46
468		01/23/2019 18:05:33
469		01/23/2019 18:05:32
470		01/23/2019 18:05:19
471		01/23/2019 18:05:18
472	15227	01/23/2019 18:05:17
473	15295	01/23/2019 18:05:17
474	13939	01/23/2019 18:04:58
475		01/23/2019 18:04:58
476	15295	01/23/2019 18:04:54
477	11680	01/23/2019 18:03:55
478	15329	01/23/2019 18:03:54
479		01/23/2019 18:03:49
480		01/23/2019 18:03:49
481		01/23/2019 18:03:48
482		01/23/2019 18:03:30
483	12305	01/23/2019 18:03:18
484		01/23/2019 18:03:05
485	14237	01/23/2019 18:02:56
486	14376	01/23/2019 18:02:56
487	12305	01/23/2019 18:02:56
488		01/23/2019 18:02:55
489		01/23/2019 18:02:41
490		01/23/2019 18:02:25
491	13939	01/23/2019 18:02:16
492	15116	01/23/2019 18:02:04
493		01/23/2019 18:01:58
494	13788	01/23/2019 18:01:56
495	15250	01/23/2019 18:01:38
496	14932	01/23/2019 18:01:12
497	12305	01/23/2019 18:01:10
498	_378	01/23/2019 18:01:07
499	14734	01/23/2019 18:01:04
500	15333	01/23/2019 18:00:55
501	14896	01/23/2019 18:00:52
502	10632	01/23/2019 18:00:52
503		01/23/2019 18:00:52
504	15237	01/23/2019 18:00:51
505	14932	01/23/2019 18:00:41
506	15116	01/23/2019 18:00:39
507	15215	01/23/2019 18:00:20
508		01/23/2019 18:00:00
509		01/23/2019 17:59:59
510		01/23/2019 17:59:56
511		01/23/2019 17:59:48
512	15177	01/23/2019 17:59:45
513		01/23/2019 17:59:43
514	12563	01/23/2019 17:59:41
515		01/23/2019 17:59:32
516	15116	01/23/2019 17:59:12
517		01/23/2019 17:59:10
518		01/23/2019 17:59:06
519		01/23/2019 17:58:56
520		01/23/2019 17:58:26
521	13999	01/23/2019 17:58:25
522	13939	01/23/2019 17:58:10
523	11937	01/23/2019 17:58:07
524		01/23/2019 17:57:49
525		01/23/2019 17:57:47
526	11937	01/23/2019 17:57:41
527	15278	01/23/2019 17:57:38
528		01/23/2019 17:57:35
529		01/23/2019 17:57:28
530		01/23/2019 17:57:27
531	15274	01/23/2019 17:57:27
532	14826	01/23/2019 17:57:07
533		01/23/2019 17:57:06
534	10612	01/23/2019 17:56:53
535	14376	01/23/2019 17:56:38
536	14503	01/23/2019 17:56:37
537		01/23/2019 17:56:31
538	13893	01/23/2019 17:56:30
539	14309	01/23/2019 17:56:18
540	12571	01/23/2019 17:56:02
541	_FF3029	01/23/2019 17:55:55
542	15243	01/23/2019 17:55:29
543	11519	01/23/2019 17:55:19
544	13626	01/23/2019 17:55:14
545		01/23/2019 17:55:04
546		01/23/2019 17:54:58
547	13890	01/23/2019 17:54:49
548	14385	01/23/2019 17:54:18
549	15406	01/23/2019 17:54:10
550		01/23/2019 17:54:09
551		01/23/2019 17:54:02
552	15098	01/23/2019 17:53:49
553	15328	01/23/2019 17:53:46
554	15296	01/23/2019 17:53:36
555	_5353	01/23/2019 17:53:29
556	13626	01/23/2019 17:53:25
557		01/23/2019 17:53:12
558	13003	01/23/2019 17:53:10
559		01/23/2019 17:52:49
560	14133	01/23/2019 17:52:42
561		01/23/2019 17:52:40
562	15277	01/23/2019 17:52:39
563		01/23/2019 17:52:34
564	15212	01/23/2019 17:52:32
565	13905	01/23/2019 17:52:31
566		01/23/2019 17:52:21
567		01/23/2019 17:52:16
568		01/23/2019 17:52:16
569	15406	01/23/2019 17:52:10
570	15177	01/23/2019 17:52:05
571		01/23/2019 17:51:50
572	14604	01/23/2019 17:51:46
573		01/23/2019 17:51:21
574	14896	01/23/2019 17:50:55
575	14096	01/23/2019 17:50:44
576	15215	01/23/2019 17:50:40
577		01/23/2019 17:50:31
578		01/23/2019 17:50:22
579	13589	01/23/2019 17:50:12
580	12995	01/23/2019 17:49:51
581	10632	01/23/2019 17:49:43
582	15099	01/23/2019 17:49:23
583	12554	01/23/2019 17:49:14
584	15435	01/23/2019 17:49:04
585	_376	01/23/2019 17:49:00
586	14269	01/23/2019 17:48:56
587		01/23/2019 17:48:48
588	12078	01/23/2019 17:48:40
589	15099	01/23/2019 17:48:12
590	12305	01/23/2019 17:48:13
591		01/23/2019 17:48:06
592	14133	01/23/2019 17:48:05
593	11221	01/23/2019 17:48:01
594	13487	01/23/2019 17:47:56
595		01/23/2019 17:47:53
596	14230	01/23/2019 17:47:42
597		01/23/2019 17:47:41
598	12020	01/23/2019 17:47:38
599		01/23/2019 17:47:35
600		01/23/2019 17:47:29
601		01/23/2019 17:47:27
602	12305	01/23/2019 17:47:21
603	15277	01/23/2019 17:47:17
604	_376	01/23/2019 17:47:13
605	14360	01/23/2019 17:46:38
606	15278	01/23/2019 17:46:35
607	12020	01/23/2019 17:45:34
608	11230	01/23/2019 17:45:20
609		01/23/2019 17:45:18
610	_668	01/23/2019 17:45:17
611	13906	01/23/2019 17:45:12
612	15296	01/23/2019 17:45:01
613	13789	01/23/2019 17:44:57
614		01/23/2019 17:44:55
615	15255	01/23/2019 17:44:36
616	10832	01/23/2019 17:44:12
617	13524	01/23/2019 17:43:46
618	14596	01/23/2019 17:43:31
619		01/23/2019 17:42:40
620		01/23/2019 17:42:40
621	10832	01/23/2019 17:42:34
622	10908	01/23/2019 17:41:42
623	10568	01/23/2019 17:41:40
624	15296	01/23/2019 17:41:39
625	13487	01/23/2019 17:40:15
626	13487	01/23/2019 17:39:52
627	11276	01/23/2019 17:39:43
628	13397	01/23/2019 17:39:42
629		01/23/2019 17:39:42
630	15333	01/23/2019 17:39:38
631	13788	01/23/2019 17:39:28
632	14376	01/23/2019 17:39:06
633	11680	01/23/2019 17:39:01
634		01/23/2019 17:39:01
635	15098	01/23/2019 17:38:57
636	15328	01/23/2019 17:38:53
637	15328	01/23/2019 17:38:50
638	15328	01/23/2019 17:38:45
639	10908	01/23/2019 17:38:26
640	11672	01/23/2019 17:38:07
641	10682	01/23/2019 17:37:55
642	14360	01/23/2019 17:37:13
643	14376	01/23/2019 17:37:04
644	10755	01/23/2019 17:37:03
645	15365	01/23/2019 17:36:18
646	10917	01/23/2019 17:36:10
647	10854	01/23/2019 17:35:48
648		01/23/2019 17:35:38
649	15435	01/23/2019 17:35:32
650	13999	01/23/2019 17:35:32
651	_668	01/23/2019 17:35:30
652		01/23/2019 17:35:29
653	14536	01/23/2019 17:34:55
654	10454	01/23/2019 17:34:47
655	10917	01/23/2019 17:34:42
656	13151	01/23/2019 17:34:34
657	13999	01/23/2019 17:34:34
658	12849	01/23/2019 17:33:57
659	_668	01/23/2019 17:33:55
660	14845	01/23/2019 17:33:20
661	15243	01/23/2019 17:33:18
662	13890	01/23/2019 17:33:15
663	14845	01/23/2019 17:33:01
664	15356	01/23/2019 17:32:34
665		01/23/2019 17:32:33
666		01/23/2019 17:32:27
Jan 2019

 

[BSALV]

(i don't know your excel version, perhaps this isn't true in an older version).
When you create a pivottable, you have to select the "add data to the datamodel" as last line in the 1st popup (see screenshots).
By doing so, you 'll have an extra option "unique count".
With an existing pivottable, that's not possible, so make a new pivottable.

.

 

[marshak]

Awesome! I will try that now and let you know if I have any more questions. Thanks so much for taking the time to reply.

 

[marshak]

Works great -- just what I needed. Many many many thanks!!