Calculate how many rooms an attendee visited

[johns_st]

I have been doing a google search and trying every possible scenario suggested for the past four hours trying to create a formula that works but have had no success. I'm trying to analyze conference data downloaded from our scanners and need to see how many times an attendee changed rooms during the day as they have the option to stay in one location, or move about at each break. Out of the multiple columns, I only believe I need the formula to evaluate two columns: "Full Name" and "Session Location". There are seven different courses each day, so I'm trying to create seven different formulas which result in the following:

1) Number of Attendees who visited 1 location
2) Number of Attendees who visited 2 locations
3) ...
4) ...
5) ...
6) ...
7) Number of Attendees who visited 7 locations

Any advice is appreciated!

 

[etaf]

can we see the layout of the data

maybe a countifs( name range , name , session location range , location )
but what if the go from 1 location to 2 location back to 1 - is that 3

 

[johns_st]

can we see the layout of the data

maybe a countifs( name range , name , session location range , location )
but what if the go from 1 location to 2 location back to 1 - is that 3

TSS Test1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	D	S	T	Session Location	Full Name	Confirmation Number	Invitee Status	Session Check-In Date (GMT-08:00) Pacific [US & Canada]	Duration (Minutes)	Attendance Type	Checkout Date (GMT-08:00) Pacific [US & Canada]	Agenda Item Code
2	1	1	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 07:17		OnArrival	2022-08-09 08:23	1111
3	1	2	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:21	1211
4	1	3	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 09:33		OnArrival	2022-08-09 10:34	1311
5	1	4	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 10:45		OnArrival	2022-08-09 11:34	1411
6	1	5	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 12:51		OnArrival	2022-08-09 13:50	1511
7	1	6	10	SONOMA C & D	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 13:58		OnArrival	2022-08-09 14:53	1610
8	1	1	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 07:31		Planner Edit		1104
9	1	2	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 08:30		OnArrival	2022-08-09 09:29	1204
10	1	3	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 09:42		OnArrival	2022-08-09 10:32	1304
11	1	4	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 10:39		OnArrival	2022-08-09 11:32	1404
12	1	6	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 13:59		OnArrival	2022-08-09 14:51	1604
13	1	7	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 14:57		OnArrival	2022-08-09 15:52	1704
14	1	1	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:22	1111
15	1	2	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:20	1211
16	1	3	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 09:39		OnArrival	2022-08-09 10:32	1311
17	1	4	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 10:42		OnArrival	2022-08-09 11:32	1411
18	1	5	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 12:59		OnArrival	2022-08-09 13:49	1511
19	1	6	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 14:00		OnArrival	2022-08-09 14:50	1611
20	1	1	04	NAPA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 07:36		OnArrival		1104
21	1	1	10	SONOMA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 07:35		OnArrival	2022-08-09 07:35	1110
22	1	2	04	NAPA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 08:30		OnArrival	2022-08-09 09:23	1204
23	1	3	04	NAPA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 09:38		OnArrival	2022-08-09 10:29	1304
24	1	4	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 10:38		OnArrival	2022-08-09 11:29	1411
25	1	5	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 12:55		OnArrival	2022-08-09 13:52	1511
26	1	6	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 13:57		OnArrival	2022-08-09 14:55	1611
27	1	7	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 15:00		OnArrival	2022-08-09 15:50	1711
28	1	6	02	GRAND BALLROOM B	Acevedo, Dominic	7SN6NK9FK8X	Accepted	2022-08-09 13:56		OnArrival	2022-08-09 14:50	1602
29	1	7	08	NAPA A & B	Acevedo, Dominic	7SN6NK9FK8X	Accepted	2022-08-09 15:02		OnArrival	2022-08-09 15:47	1708
30	1	1	11	GRAND BALLROOM A	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 07:24		OnArrival	2022-08-09 08:23	1111
31	1	2	11	GRAND BALLROOM A	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:21	1211
32	1	3	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 09:29		OnArrival	2022-08-09 10:33	1306
33	1	4	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 10:42		OnArrival	2022-08-09 11:33	1406
34	1	5	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 12:47		OnArrival	2022-08-09 13:56	1506
35	1	6	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 13:56		OnArrival	2022-08-09 14:53	1606
36	1	1	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:25	1111
37	1	2	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 08:28		OnArrival	2022-08-09 09:24	1211
38	1	3	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 09:29		OnArrival	2022-08-09 10:34	1311
39	1	4	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 10:37		OnArrival	2022-08-09 11:29	1411
40	1	5	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 12:51		OnArrival	2022-08-09 13:52	1511
41	1	6	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 13:57		OnArrival	2022-08-09 14:52	1611
42	1	1	11	GRAND BALLROOM A	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:23	1111
43	1	2	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 08:32		OnArrival	2022-08-09 09:27	1204
44	1	3	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 09:39		OnArrival	2022-08-09 10:31	1304
45	1	4	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 10:39		OnArrival	2022-08-09 11:30	1404
46	1	5	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 12:59		OnArrival	2022-08-09 13:49	1504
47	1	6	10	SONOMA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 13:51		OnArrival	2022-08-09 14:52	1610
48	1	7	11	GRAND BALLROOM A	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 15:01		OnArrival	2022-08-09 15:50	1711
49	1	1	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:21	1111
50	1	2	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 08:30		OnArrival	2022-08-09 09:21	1211
51	1	3	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 09:34		OnArrival	2022-08-09 10:31	1311
52	1	4	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 10:41		OnArrival	2022-08-09 11:31	1411
53	1	5	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 12:54		OnArrival	2022-08-09 13:52	1511
54	1	6	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 13:59		OnArrival	2022-08-09 14:52	1611
55	1	7	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 14:59		OnArrival	2022-08-09 15:52	1711
56	1	2	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:24	1210
57	1	3	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 09:37		OnArrival	2022-08-09 10:31	1310
58	1	4	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 10:40		OnArrival	2022-08-09 11:33	1410
59	1	5	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 12:59		OnArrival	2022-08-09 13:50	1510
60	1	6	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 13:57		OnArrival	2022-08-09 14:51	1610
61	1	7	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 14:58		OnArrival	2022-08-09 15:50	1710
62	1	3	02	GRAND BALLROOM B	Adame, Kyle	39NZLQ44BZ8	Accepted	2022-08-09 09:43		OnArrival	2022-08-09 10:34	1302
63	1	5	06	SHOWROOM	Adame, Kyle	39NZLQ44BZ8	Accepted	2022-08-09 12:58		OnArrival	2022-08-09 13:54	1506
64	1	3	11	GRAND BALLROOM A	Adams, Brad	FWNR74N8TL9	Accepted	2022-08-09 09:34		OnArrival	2022-08-09 10:31	1311
65	1	2	02	GRAND BALLROOM B	Adams, Randy	BJNLCQHR3CC	Accepted	2022-08-09 08:27		OnArrival	2022-08-09 09:23	1202
66	1	3	02	GRAND BALLROOM B	Adams, Randy	BJNLCQHR3CC	Accepted	2022-08-09 09:35		OnArrival	2022-08-09 10:31	1302
67	1	4	08	NAPA A & B	Adams, Randy	BJNLCQHR3CC	Accepted	2022-08-09 10:42		OnArrival	2022-08-09 11:33	1408
68	1	2	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 08:26		OnArrival	2022-08-09 09:24	1210
69	1	3	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 09:39		OnArrival	2022-08-09 10:33	1310
70	1	4	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 10:37		OnArrival	2022-08-09 11:33	1410
71	1	5	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 12:50		OnArrival	2022-08-09 13:52	1510
72	1	6	03	SONOMA A	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 13:56		OnArrival	2022-08-09 14:52	1603
73	1	7	03	SONOMA A	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 15:00		OnArrival	2022-08-09 15:53	1703
Tuesday

Cell Formulas
Range	Formula
K2	K2	=DATE(2022,8,9)+TIME(8,23,57)
K3	K3	=DATE(2022,8,9)+TIME(9,21,2)
K4	K4	=DATE(2022,8,9)+TIME(10,34,7)
K5	K5	=DATE(2022,8,9)+TIME(11,34,42)
K6	K6	=DATE(2022,8,9)+TIME(13,50,35)
K7	K7	=DATE(2022,8,9)+TIME(14,53,25)
K9	K9	=DATE(2022,8,9)+TIME(9,29,23)
K10	K10	=DATE(2022,8,9)+TIME(10,32,27)
K11	K11	=DATE(2022,8,9)+TIME(11,32,13)
K12	K12	=DATE(2022,8,9)+TIME(14,51,32)
K13	K13	=DATE(2022,8,9)+TIME(15,52,19)
K14	K14	=DATE(2022,8,9)+TIME(8,22,36)
K15	K15	=DATE(2022,8,9)+TIME(9,20,53)
K16	K16	=DATE(2022,8,9)+TIME(10,32,29)
K17	K17	=DATE(2022,8,9)+TIME(11,32,12)
K18	K18	=DATE(2022,8,9)+TIME(13,49,44)
K19	K19	=DATE(2022,8,9)+TIME(14,50,8)
H2	H2	=DATE(2022,8,9)+TIME(7,17,9)
H3	H3	=DATE(2022,8,9)+TIME(8,31,27)
H4	H4	=DATE(2022,8,9)+TIME(9,33,23)
H5	H5	=DATE(2022,8,9)+TIME(10,45,2)
H6	H6	=DATE(2022,8,9)+TIME(12,51,58)
H7	H7	=DATE(2022,8,9)+TIME(13,58,2)
H8	H8	=DATE(2022,8,9)+TIME(7,31,19)
H9	H9	=DATE(2022,8,9)+TIME(8,30,15)
H10	H10	=DATE(2022,8,9)+TIME(9,42,30)
H11	H11	=DATE(2022,8,9)+TIME(10,39,30)
H12	H12	=DATE(2022,8,9)+TIME(13,59,15)
H13	H13	=DATE(2022,8,9)+TIME(14,57,45)
H14	H14	=DATE(2022,8,9)+TIME(7,16,3)
H15	H15	=DATE(2022,8,9)+TIME(8,31,10)
H16	H16	=DATE(2022,8,9)+TIME(9,39,41)
H17	H17	=DATE(2022,8,9)+TIME(10,42,49)
H18	H18	=DATE(2022,8,9)+TIME(12,59,4)
H19	H19	=DATE(2022,8,9)+TIME(14,0,15)
H20	H20	=DATE(2022,8,9)+TIME(7,36,19)
H21	H21	=DATE(2022,8,9)+TIME(7,35,31)
H22	H22	=DATE(2022,8,9)+TIME(8,30,51)
H23	H23	=DATE(2022,8,9)+TIME(9,38,17)
H24	H24	=DATE(2022,8,9)+TIME(10,38,29)
H25	H25	=DATE(2022,8,9)+TIME(12,55,45)
H26	H26	=DATE(2022,8,9)+TIME(13,57,56)
H27	H27	=DATE(2022,8,9)+TIME(15,0,21)
H28	H28	=DATE(2022,8,9)+TIME(13,56,42)
H29	H29	=DATE(2022,8,9)+TIME(15,2,47)
H30	H30	=DATE(2022,8,9)+TIME(7,24,43)
H31	H31	=DATE(2022,8,9)+TIME(8,31,36)
H32	H32	=DATE(2022,8,9)+TIME(9,29,49)
H33	H33	=DATE(2022,8,9)+TIME(10,42,56)
H34	H34	=DATE(2022,8,9)+TIME(12,47,6)
H35	H35	=DATE(2022,8,9)+TIME(13,56,59)
H36	H36	=DATE(2022,8,9)+TIME(7,16,14)
H37	H37	=DATE(2022,8,9)+TIME(8,28,38)
H38	H38	=DATE(2022,8,9)+TIME(9,29,18)
H39	H39	=DATE(2022,8,9)+TIME(10,37,51)
H40	H40	=DATE(2022,8,9)+TIME(12,51,42)
H41	H41	=DATE(2022,8,9)+TIME(13,57,47)
H42	H42	=DATE(2022,8,9)+TIME(7,16,19)
H43	H43	=DATE(2022,8,9)+TIME(8,32,33)
H44	H44	=DATE(2022,8,9)+TIME(9,39,5)
H45	H45	=DATE(2022,8,9)+TIME(10,39,32)
H46	H46	=DATE(2022,8,9)+TIME(12,59,38)
H47	H47	=DATE(2022,8,9)+TIME(13,51,56)
H48	H48	=DATE(2022,8,9)+TIME(15,1,28)
H49	H49	=DATE(2022,8,9)+TIME(7,16,59)
H50	H50	=DATE(2022,8,9)+TIME(8,30,6)
H51	H51	=DATE(2022,8,9)+TIME(9,34,44)
H52	H52	=DATE(2022,8,9)+TIME(10,41,26)
H53	H53	=DATE(2022,8,9)+TIME(12,54,38)
H54	H54	=DATE(2022,8,9)+TIME(13,59,51)
H55	H55	=DATE(2022,8,9)+TIME(14,59,56)
H56	H56	=DATE(2022,8,9)+TIME(8,31,35)
H57	H57	=DATE(2022,8,9)+TIME(9,37,16)
H58	H58	=DATE(2022,8,9)+TIME(10,40,29)
H59	H59	=DATE(2022,8,9)+TIME(12,59,41)
H60	H60	=DATE(2022,8,9)+TIME(13,57,38)
H61	H61	=DATE(2022,8,9)+TIME(14,58,11)
H62	H62	=DATE(2022,8,9)+TIME(9,43,57)
H63	H63	=DATE(2022,8,9)+TIME(12,58,34)
H64	H64	=DATE(2022,8,9)+TIME(9,34,54)
H65	H65	=DATE(2022,8,9)+TIME(8,27,52)
H66	H66	=DATE(2022,8,9)+TIME(9,35,42)
H67	H67	=DATE(2022,8,9)+TIME(10,42,55)
H68	H68	=DATE(2022,8,9)+TIME(8,26,59)
H69	H69	=DATE(2022,8,9)+TIME(9,39,33)
H70	H70	=DATE(2022,8,9)+TIME(10,37,10)
H71	H71	=DATE(2022,8,9)+TIME(12,50,45)
H72	H72	=DATE(2022,8,9)+TIME(13,56,38)
H73	H73	=DATE(2022,8,9)+TIME(15,0,4)
K21	K21	=DATE(2022,8,9)+TIME(7,35,40)
K22	K22	=DATE(2022,8,9)+TIME(9,23,51)
K23	K23	=DATE(2022,8,9)+TIME(10,29,23)
K24	K24	=DATE(2022,8,9)+TIME(11,29,52)
K25	K25	=DATE(2022,8,9)+TIME(13,52,43)
K26	K26	=DATE(2022,8,9)+TIME(14,55,52)
K27	K27	=DATE(2022,8,9)+TIME(15,50,8)
K28	K28	=DATE(2022,8,9)+TIME(14,50,32)
K29	K29	=DATE(2022,8,9)+TIME(15,47,51)
K30	K30	=DATE(2022,8,9)+TIME(8,23,14)
K31	K31	=DATE(2022,8,9)+TIME(9,21,18)
K32	K32	=DATE(2022,8,9)+TIME(10,33,58)
K33	K33	=DATE(2022,8,9)+TIME(11,33,26)
K34	K34	=DATE(2022,8,9)+TIME(13,56,0)
K35	K35	=DATE(2022,8,9)+TIME(14,53,30)
K36	K36	=DATE(2022,8,9)+TIME(8,25,43)
K37	K37	=DATE(2022,8,9)+TIME(9,24,23)
K38	K38	=DATE(2022,8,9)+TIME(10,34,31)
K39	K39	=DATE(2022,8,9)+TIME(11,29,53)
K40	K40	=DATE(2022,8,9)+TIME(13,52,29)
K41	K41	=DATE(2022,8,9)+TIME(14,52,10)
K42	K42	=DATE(2022,8,9)+TIME(8,23,4)
K43	K43	=DATE(2022,8,9)+TIME(9,27,11)
K44	K44	=DATE(2022,8,9)+TIME(10,31,42)
K45	K45	=DATE(2022,8,9)+TIME(11,30,21)
K46	K46	=DATE(2022,8,9)+TIME(13,49,59)
K47	K47	=DATE(2022,8,9)+TIME(14,52,24)
K48	K48	=DATE(2022,8,9)+TIME(15,50,35)
K49	K49	=DATE(2022,8,9)+TIME(8,21,50)
K50	K50	=DATE(2022,8,9)+TIME(9,21,7)
K51	K51	=DATE(2022,8,9)+TIME(10,31,52)
K52	K52	=DATE(2022,8,9)+TIME(11,31,34)
K53	K53	=DATE(2022,8,9)+TIME(13,52,14)
K54	K54	=DATE(2022,8,9)+TIME(14,52,44)
K55	K55	=DATE(2022,8,9)+TIME(15,52,25)
K56	K56	=DATE(2022,8,9)+TIME(9,24,22)
K57	K57	=DATE(2022,8,9)+TIME(10,31,59)
K58	K58	=DATE(2022,8,9)+TIME(11,33,9)
K59	K59	=DATE(2022,8,9)+TIME(13,50,50)
K60	K60	=DATE(2022,8,9)+TIME(14,51,36)
K61	K61	=DATE(2022,8,9)+TIME(15,50,56)
K62	K62	=DATE(2022,8,9)+TIME(10,34,48)
K63	K63	=DATE(2022,8,9)+TIME(13,54,46)
K64	K64	=DATE(2022,8,9)+TIME(10,31,47)
K65	K65	=DATE(2022,8,9)+TIME(9,23,36)
K66	K66	=DATE(2022,8,9)+TIME(10,31,53)
K67	K67	=DATE(2022,8,9)+TIME(11,33,55)
K68	K68	=DATE(2022,8,9)+TIME(9,24,28)
K69	K69	=DATE(2022,8,9)+TIME(10,33,20)
K70	K70	=DATE(2022,8,9)+TIME(11,33,47)
K71	K71	=DATE(2022,8,9)+TIME(13,52,23)
K72	K72	=DATE(2022,8,9)+TIME(14,52,29)
K73	K73	=DATE(2022,8,9)+TIME(15,53,28)

 

[johns_st]

TSS Test1.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	D	S	T	Session Location	Full Name	Confirmation Number	Invitee Status	Session Check-In Date (GMT-08:00) Pacific [US & Canada]	Duration (Minutes)	Attendance Type	Checkout Date (GMT-08:00) Pacific [US & Canada]	Agenda Item Code
2	1	1	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 07:17		OnArrival	2022-08-09 08:23	1111
3	1	2	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:21	1211
4	1	3	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 09:33		OnArrival	2022-08-09 10:34	1311
5	1	4	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 10:45		OnArrival	2022-08-09 11:34	1411
6	1	5	11	GRAND BALLROOM A	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 12:51		OnArrival	2022-08-09 13:50	1511
7	1	6	10	SONOMA C & D	Abbott, Patrick	6ZN6PS4JY59	Accepted	2022-08-09 13:58		OnArrival	2022-08-09 14:53	1610
8	1	1	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 07:31		Planner Edit		1104
9	1	2	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 08:30		OnArrival	2022-08-09 09:29	1204
10	1	3	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 09:42		OnArrival	2022-08-09 10:32	1304
11	1	4	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 10:39		OnArrival	2022-08-09 11:32	1404
12	1	6	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 13:59		OnArrival	2022-08-09 14:51	1604
13	1	7	04	NAPA C & D	Abell, Ryan	36N7QN3PMVQ	Accepted	2022-08-09 14:57		OnArrival	2022-08-09 15:52	1704
14	1	1	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:22	1111
15	1	2	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:20	1211
16	1	3	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 09:39		OnArrival	2022-08-09 10:32	1311
17	1	4	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 10:42		OnArrival	2022-08-09 11:32	1411
18	1	5	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 12:59		OnArrival	2022-08-09 13:49	1511
19	1	6	11	GRAND BALLROOM A	Abeyta, Raymond	5LN64ZC4FLL	Accepted	2022-08-09 14:00		OnArrival	2022-08-09 14:50	1611
20	1	1	04	NAPA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 07:36		OnArrival		1104
21	1	1	10	SONOMA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 07:35		OnArrival	2022-08-09 07:35	1110
22	1	2	04	NAPA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 08:30		OnArrival	2022-08-09 09:23	1204
23	1	3	04	NAPA C & D	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 09:38		OnArrival	2022-08-09 10:29	1304
24	1	4	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 10:38		OnArrival	2022-08-09 11:29	1411
25	1	5	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 12:55		OnArrival	2022-08-09 13:52	1511
26	1	6	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 13:57		OnArrival	2022-08-09 14:55	1611
27	1	7	11	GRAND BALLROOM A	Accad, Angelito	3FNT5242DTN	Accepted	2022-08-09 15:00		OnArrival	2022-08-09 15:50	1711
28	1	6	02	GRAND BALLROOM B	Acevedo, Dominic	7SN6NK9FK8X	Accepted	2022-08-09 13:56		OnArrival	2022-08-09 14:50	1602
29	1	7	08	NAPA A & B	Acevedo, Dominic	7SN6NK9FK8X	Accepted	2022-08-09 15:02		OnArrival	2022-08-09 15:47	1708
30	1	1	11	GRAND BALLROOM A	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 07:24		OnArrival	2022-08-09 08:23	1111
31	1	2	11	GRAND BALLROOM A	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:21	1211
32	1	3	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 09:29		OnArrival	2022-08-09 10:33	1306
33	1	4	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 10:42		OnArrival	2022-08-09 11:33	1406
34	1	5	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 12:47		OnArrival	2022-08-09 13:56	1506
35	1	6	06	SHOWROOM	Acevedo, Jose	3TNLS2JZWBF	Accepted	2022-08-09 13:56		OnArrival	2022-08-09 14:53	1606
36	1	1	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:25	1111
37	1	2	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 08:28		OnArrival	2022-08-09 09:24	1211
38	1	3	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 09:29		OnArrival	2022-08-09 10:34	1311
39	1	4	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 10:37		OnArrival	2022-08-09 11:29	1411
40	1	5	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 12:51		OnArrival	2022-08-09 13:52	1511
41	1	6	11	GRAND BALLROOM A	Aceves, Danny	SHNR8B4YR8H	Accepted	2022-08-09 13:57		OnArrival	2022-08-09 14:52	1611
42	1	1	11	GRAND BALLROOM A	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:23	1111
43	1	2	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 08:32		OnArrival	2022-08-09 09:27	1204
44	1	3	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 09:39		OnArrival	2022-08-09 10:31	1304
45	1	4	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 10:39		OnArrival	2022-08-09 11:30	1404
46	1	5	04	NAPA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 12:59		OnArrival	2022-08-09 13:49	1504
47	1	6	10	SONOMA C & D	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 13:51		OnArrival	2022-08-09 14:52	1610
48	1	7	11	GRAND BALLROOM A	Acosta, Jose	F7NBW4F5F32	Accepted	2022-08-09 15:01		OnArrival	2022-08-09 15:50	1711
49	1	1	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 07:16		OnArrival	2022-08-09 08:21	1111
50	1	2	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 08:30		OnArrival	2022-08-09 09:21	1211
51	1	3	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 09:34		OnArrival	2022-08-09 10:31	1311
52	1	4	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 10:41		OnArrival	2022-08-09 11:31	1411
53	1	5	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 12:54		OnArrival	2022-08-09 13:52	1511
54	1	6	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 13:59		OnArrival	2022-08-09 14:52	1611
55	1	7	11	GRAND BALLROOM A	Acosta, Roberto	X9NVGNP924G	Accepted	2022-08-09 14:59		OnArrival	2022-08-09 15:52	1711
56	1	2	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 08:31		OnArrival	2022-08-09 09:24	1210
57	1	3	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 09:37		OnArrival	2022-08-09 10:31	1310
58	1	4	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 10:40		OnArrival	2022-08-09 11:33	1410
59	1	5	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 12:59		OnArrival	2022-08-09 13:50	1510
60	1	6	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 13:57		OnArrival	2022-08-09 14:51	1610
61	1	7	10	SONOMA C & D	Acosta, Ruben	T7N69SKRYG2	Accepted	2022-08-09 14:58		OnArrival	2022-08-09 15:50	1710
62	1	3	02	GRAND BALLROOM B	Adame, Kyle	39NZLQ44BZ8	Accepted	2022-08-09 09:43		OnArrival	2022-08-09 10:34	1302
63	1	5	06	SHOWROOM	Adame, Kyle	39NZLQ44BZ8	Accepted	2022-08-09 12:58		OnArrival	2022-08-09 13:54	1506
64	1	3	11	GRAND BALLROOM A	Adams, Brad	FWNR74N8TL9	Accepted	2022-08-09 09:34		OnArrival	2022-08-09 10:31	1311
65	1	2	02	GRAND BALLROOM B	Adams, Randy	BJNLCQHR3CC	Accepted	2022-08-09 08:27		OnArrival	2022-08-09 09:23	1202
66	1	3	02	GRAND BALLROOM B	Adams, Randy	BJNLCQHR3CC	Accepted	2022-08-09 09:35		OnArrival	2022-08-09 10:31	1302
67	1	4	08	NAPA A & B	Adams, Randy	BJNLCQHR3CC	Accepted	2022-08-09 10:42		OnArrival	2022-08-09 11:33	1408
68	1	2	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 08:26		OnArrival	2022-08-09 09:24	1210
69	1	3	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 09:39		OnArrival	2022-08-09 10:33	1310
70	1	4	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 10:37		OnArrival	2022-08-09 11:33	1410
71	1	5	10	SONOMA C & D	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 12:50		OnArrival	2022-08-09 13:52	1510
72	1	6	03	SONOMA A	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 13:56		OnArrival	2022-08-09 14:52	1603
73	1	7	03	SONOMA A	Adams, Richard	8PNT5LT2YP9	Accepted	2022-08-09 15:00		OnArrival	2022-08-09 15:53	1703
Tuesday

Cell Formulas
Range	Formula
K2	K2	=DATE(2022,8,9)+TIME(8,23,57)
K3	K3	=DATE(2022,8,9)+TIME(9,21,2)
K4	K4	=DATE(2022,8,9)+TIME(10,34,7)
K5	K5	=DATE(2022,8,9)+TIME(11,34,42)
K6	K6	=DATE(2022,8,9)+TIME(13,50,35)
K7	K7	=DATE(2022,8,9)+TIME(14,53,25)
K9	K9	=DATE(2022,8,9)+TIME(9,29,23)
K10	K10	=DATE(2022,8,9)+TIME(10,32,27)
K11	K11	=DATE(2022,8,9)+TIME(11,32,13)
K12	K12	=DATE(2022,8,9)+TIME(14,51,32)
K13	K13	=DATE(2022,8,9)+TIME(15,52,19)
K14	K14	=DATE(2022,8,9)+TIME(8,22,36)
K15	K15	=DATE(2022,8,9)+TIME(9,20,53)
K16	K16	=DATE(2022,8,9)+TIME(10,32,29)
K17	K17	=DATE(2022,8,9)+TIME(11,32,12)
K18	K18	=DATE(2022,8,9)+TIME(13,49,44)
K19	K19	=DATE(2022,8,9)+TIME(14,50,8)
H2	H2	=DATE(2022,8,9)+TIME(7,17,9)
H3	H3	=DATE(2022,8,9)+TIME(8,31,27)
H4	H4	=DATE(2022,8,9)+TIME(9,33,23)
H5	H5	=DATE(2022,8,9)+TIME(10,45,2)
H6	H6	=DATE(2022,8,9)+TIME(12,51,58)
H7	H7	=DATE(2022,8,9)+TIME(13,58,2)
H8	H8	=DATE(2022,8,9)+TIME(7,31,19)
H9	H9	=DATE(2022,8,9)+TIME(8,30,15)
H10	H10	=DATE(2022,8,9)+TIME(9,42,30)
H11	H11	=DATE(2022,8,9)+TIME(10,39,30)
H12	H12	=DATE(2022,8,9)+TIME(13,59,15)
H13	H13	=DATE(2022,8,9)+TIME(14,57,45)
H14	H14	=DATE(2022,8,9)+TIME(7,16,3)
H15	H15	=DATE(2022,8,9)+TIME(8,31,10)
H16	H16	=DATE(2022,8,9)+TIME(9,39,41)
H17	H17	=DATE(2022,8,9)+TIME(10,42,49)
H18	H18	=DATE(2022,8,9)+TIME(12,59,4)
H19	H19	=DATE(2022,8,9)+TIME(14,0,15)
H20	H20	=DATE(2022,8,9)+TIME(7,36,19)
H21	H21	=DATE(2022,8,9)+TIME(7,35,31)
H22	H22	=DATE(2022,8,9)+TIME(8,30,51)
H23	H23	=DATE(2022,8,9)+TIME(9,38,17)
H24	H24	=DATE(2022,8,9)+TIME(10,38,29)
H25	H25	=DATE(2022,8,9)+TIME(12,55,45)
H26	H26	=DATE(2022,8,9)+TIME(13,57,56)
H27	H27	=DATE(2022,8,9)+TIME(15,0,21)
H28	H28	=DATE(2022,8,9)+TIME(13,56,42)
H29	H29	=DATE(2022,8,9)+TIME(15,2,47)
H30	H30	=DATE(2022,8,9)+TIME(7,24,43)
H31	H31	=DATE(2022,8,9)+TIME(8,31,36)
H32	H32	=DATE(2022,8,9)+TIME(9,29,49)
H33	H33	=DATE(2022,8,9)+TIME(10,42,56)
H34	H34	=DATE(2022,8,9)+TIME(12,47,6)
H35	H35	=DATE(2022,8,9)+TIME(13,56,59)
H36	H36	=DATE(2022,8,9)+TIME(7,16,14)
H37	H37	=DATE(2022,8,9)+TIME(8,28,38)
H38	H38	=DATE(2022,8,9)+TIME(9,29,18)
H39	H39	=DATE(2022,8,9)+TIME(10,37,51)
H40	H40	=DATE(2022,8,9)+TIME(12,51,42)
H41	H41	=DATE(2022,8,9)+TIME(13,57,47)
H42	H42	=DATE(2022,8,9)+TIME(7,16,19)
H43	H43	=DATE(2022,8,9)+TIME(8,32,33)
H44	H44	=DATE(2022,8,9)+TIME(9,39,5)
H45	H45	=DATE(2022,8,9)+TIME(10,39,32)
H46	H46	=DATE(2022,8,9)+TIME(12,59,38)
H47	H47	=DATE(2022,8,9)+TIME(13,51,56)
H48	H48	=DATE(2022,8,9)+TIME(15,1,28)
H49	H49	=DATE(2022,8,9)+TIME(7,16,59)
H50	H50	=DATE(2022,8,9)+TIME(8,30,6)
H51	H51	=DATE(2022,8,9)+TIME(9,34,44)
H52	H52	=DATE(2022,8,9)+TIME(10,41,26)
H53	H53	=DATE(2022,8,9)+TIME(12,54,38)
H54	H54	=DATE(2022,8,9)+TIME(13,59,51)
H55	H55	=DATE(2022,8,9)+TIME(14,59,56)
H56	H56	=DATE(2022,8,9)+TIME(8,31,35)
H57	H57	=DATE(2022,8,9)+TIME(9,37,16)
H58	H58	=DATE(2022,8,9)+TIME(10,40,29)
H59	H59	=DATE(2022,8,9)+TIME(12,59,41)
H60	H60	=DATE(2022,8,9)+TIME(13,57,38)
H61	H61	=DATE(2022,8,9)+TIME(14,58,11)
H62	H62	=DATE(2022,8,9)+TIME(9,43,57)
H63	H63	=DATE(2022,8,9)+TIME(12,58,34)
H64	H64	=DATE(2022,8,9)+TIME(9,34,54)
H65	H65	=DATE(2022,8,9)+TIME(8,27,52)
H66	H66	=DATE(2022,8,9)+TIME(9,35,42)
H67	H67	=DATE(2022,8,9)+TIME(10,42,55)
H68	H68	=DATE(2022,8,9)+TIME(8,26,59)
H69	H69	=DATE(2022,8,9)+TIME(9,39,33)
H70	H70	=DATE(2022,8,9)+TIME(10,37,10)
H71	H71	=DATE(2022,8,9)+TIME(12,50,45)
H72	H72	=DATE(2022,8,9)+TIME(13,56,38)
H73	H73	=DATE(2022,8,9)+TIME(15,0,4)
K21	K21	=DATE(2022,8,9)+TIME(7,35,40)
K22	K22	=DATE(2022,8,9)+TIME(9,23,51)
K23	K23	=DATE(2022,8,9)+TIME(10,29,23)
K24	K24	=DATE(2022,8,9)+TIME(11,29,52)
K25	K25	=DATE(2022,8,9)+TIME(13,52,43)
K26	K26	=DATE(2022,8,9)+TIME(14,55,52)
K27	K27	=DATE(2022,8,9)+TIME(15,50,8)
K28	K28	=DATE(2022,8,9)+TIME(14,50,32)
K29	K29	=DATE(2022,8,9)+TIME(15,47,51)
K30	K30	=DATE(2022,8,9)+TIME(8,23,14)
K31	K31	=DATE(2022,8,9)+TIME(9,21,18)
K32	K32	=DATE(2022,8,9)+TIME(10,33,58)
K33	K33	=DATE(2022,8,9)+TIME(11,33,26)
K34	K34	=DATE(2022,8,9)+TIME(13,56,0)
K35	K35	=DATE(2022,8,9)+TIME(14,53,30)
K36	K36	=DATE(2022,8,9)+TIME(8,25,43)
K37	K37	=DATE(2022,8,9)+TIME(9,24,23)
K38	K38	=DATE(2022,8,9)+TIME(10,34,31)
K39	K39	=DATE(2022,8,9)+TIME(11,29,53)
K40	K40	=DATE(2022,8,9)+TIME(13,52,29)
K41	K41	=DATE(2022,8,9)+TIME(14,52,10)
K42	K42	=DATE(2022,8,9)+TIME(8,23,4)
K43	K43	=DATE(2022,8,9)+TIME(9,27,11)
K44	K44	=DATE(2022,8,9)+TIME(10,31,42)
K45	K45	=DATE(2022,8,9)+TIME(11,30,21)
K46	K46	=DATE(2022,8,9)+TIME(13,49,59)
K47	K47	=DATE(2022,8,9)+TIME(14,52,24)
K48	K48	=DATE(2022,8,9)+TIME(15,50,35)
K49	K49	=DATE(2022,8,9)+TIME(8,21,50)
K50	K50	=DATE(2022,8,9)+TIME(9,21,7)
K51	K51	=DATE(2022,8,9)+TIME(10,31,52)
K52	K52	=DATE(2022,8,9)+TIME(11,31,34)
K53	K53	=DATE(2022,8,9)+TIME(13,52,14)
K54	K54	=DATE(2022,8,9)+TIME(14,52,44)
K55	K55	=DATE(2022,8,9)+TIME(15,52,25)
K56	K56	=DATE(2022,8,9)+TIME(9,24,22)
K57	K57	=DATE(2022,8,9)+TIME(10,31,59)
K58	K58	=DATE(2022,8,9)+TIME(11,33,9)
K59	K59	=DATE(2022,8,9)+TIME(13,50,50)
K60	K60	=DATE(2022,8,9)+TIME(14,51,36)
K61	K61	=DATE(2022,8,9)+TIME(15,50,56)
K62	K62	=DATE(2022,8,9)+TIME(10,34,48)
K63	K63	=DATE(2022,8,9)+TIME(13,54,46)
K64	K64	=DATE(2022,8,9)+TIME(10,31,47)
K65	K65	=DATE(2022,8,9)+TIME(9,23,36)
K66	K66	=DATE(2022,8,9)+TIME(10,31,53)
K67	K67	=DATE(2022,8,9)+TIME(11,33,55)
K68	K68	=DATE(2022,8,9)+TIME(9,24,28)
K69	K69	=DATE(2022,8,9)+TIME(10,33,20)
K70	K70	=DATE(2022,8,9)+TIME(11,33,47)
K71	K71	=DATE(2022,8,9)+TIME(13,52,23)
K72	K72	=DATE(2022,8,9)+TIME(14,52,29)
K73	K73	=DATE(2022,8,9)+TIME(15,53,28)

can we see the layout of the data

maybe a countifs( name range , name , session location range , location )
but what if the go from 1 location to 2 location back to 1 - is that 3

I finally got the mini-sheet add-in to work so I hope the upload occurred. So to answer your question, 'Abbott, Patrick' would be calculated in the formula for those attendees that only visited one room, as well as 'Abell, Ryan' and 'Abeyta, Raymond'.

Now with the case of 'Accad, Angelito', even though he went from NAPA C&D to SONOMA C&D, then back to NAPA C&D, before going to GRAND BALLROOM A for the remainder of the day, we are only interested in the fact that he went to 3 different rooms that day (NAPA C&D would only be counted once.

So based on just those attendees, the result of the formula I would be needing should be the following:

1) Number of Attendees who visited 1 location: 3
2) Number of Attendees who visited 2 locations: 0
3) Number of Attendees who visited 3 locations: 1
4) Number of Attendees who visited 4 locations: 0
5) Number of Attendees who visited 5 locations: 0
6) Number of Attendees who visited 6 locations: 0
7) Number of Attendees who visited 7 locations: 0

I have 10,580 rows of data these formulas would be analayzing in this worksheet

 

[johns_st]

I'm pretty sure I'd need a different formula for each of the 7. Sounds like it would be a combination SUM and COUNTIF for each, but I just can't seem to get the right combo.

 

[johns_st]

If it makes it easier, column c can be utilized instead of column d for the location data as the numbers in column c match column d (if working with numbers in a formula is easier than working with text)

 

[etaf]

i have had a play - using lots of helper columns with UNIQUE () , which you have as 365 version
Just to see how to build up a formula which works and , if you like , see the working - which i often do - before using things like sumproduct

I will also put on a share , dropbox , but only for a few days

ROOMS-ATT-ETAF.xlsx

Shared with Dropbox

www.dropbox.com

In column R
I have just used UNIQUE - to pull out the
Room, Name and date (but i used INT(date) to get rid of the time and put in column F
just so we can pull 3 consecutive columns D, E & F
=UNIQUE(D:F)

as i say this is just WIP - and maybe improved

Now I have used UNIQUE again in column V - to pull all the unique Names from the unique list
so now we can count how many times the names appear in list - column W

and then use your list to count how many names are 1 , 2 , 3 etc
Column Y

But i get different results to you and may be looking at this ALL wrong
for example
Acosta, Jose
has visited various rooms , from a filter on the list
GRAND BALLROOM A
NAPA C & D
NAPA C & D
NAPA C & D
NAPA C & D
SONOMA C & D
GRAND BALLROOM A

So thats 3 rooms

As has
Accad, Angelito

NAPA C & D
SONOMA C & D
NAPA C & D
NAPA C & D
GRAND BALLROOM A
GRAND BALLROOM A
GRAND BALLROOM A
GRAND BALLROOM A

So thats
3) Number of Attendees who visited 3 locations: 1
actually 2 and not 1

as i say i maybe missing something
Heres the numbers I get v yours
1) Number of Attendees who visited 1 location: 3 = 6
2) Number of Attendees who visited 2 locations: 0 = 6
3) Number of Attendees who visited 3 locations: 1 = 2
4) Number of Attendees who visited 4 locations: 0 = 0
5) Number of Attendees who visited 5 locations: 0 = 0
6) Number of Attendees who visited 6 locations: 0 = 0
7) Number of Attendees who visited 7 locations: 0 = 0

ROOMS-ATT-ETAF.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	D	S	T	Session Location	Full Name	date	Confirmation Number	Invitee Status	Session Check-In Date (GMT-08:00) Pacific [US & Canada]	Duration (Minutes)	Attendance Type	Checkout Date (GMT-08:00) Pacific [US & Canada]	Agenda Item Code					UNIQUE ROOMS , NAME AND DATE				UNIQUE NAMES FROM OTHER UNIQUE
2	1	1	11	GRAND BALLROOM A	Abbott, Patrick	8/9/22 0:00	6ZN6PS4JY59	Accepted	8/9/22 7:17		OnArrival	8/9/22	1111									0	COUNT
3	1	2	11	GRAND BALLROOM A	Abbott, Patrick	8/9/22 0:00	6ZN6PS4JY59	Accepted	8/9/22		OnArrival	8/9/22	1211					Session Location	Full Name	date		Full Name			1) Number of Attendees who visited 1 location: 3	6
4	1	3	11	GRAND BALLROOM A	Abbott, Patrick	8/9/22 0:00	6ZN6PS4JY59	Accepted	8/9/22		OnArrival	8/9/22	1311					GRAND BALLROOM A	Abbott, Patrick	######		Abbott, Patrick	2		2) Number of Attendees who visited 2 locations: 0	6
5	1	4	11	GRAND BALLROOM A	Abbott, Patrick	8/9/22 0:00	6ZN6PS4JY59	Accepted	8/9/22		OnArrival	8/9/22	1411					SONOMA C & D	Abbott, Patrick	######		Abell, Ryan	1		3) Number of Attendees who visited 3 locations: 1	2
6	1	5	11	GRAND BALLROOM A	Abbott, Patrick	8/9/22 0:00	6ZN6PS4JY59	Accepted	8/9/22		OnArrival	8/9/22	1511					NAPA C & D	Abell, Ryan	######		Abeyta, Raymond	1		4) Number of Attendees who visited 4 locations: 0	0
7	1	6	10	SONOMA C & D	Abbott, Patrick	8/9/22 0:00	6ZN6PS4JY59	Accepted	8/9/22		OnArrival	8/9/22	1610					GRAND BALLROOM A	Abeyta, Raymond	######		Accad, Angelito	3		5) Number of Attendees who visited 5 locations: 0	0
8	1	1	4	NAPA C & D	Abell, Ryan	8/9/22 0:00	36N7QN3PMVQ	Accepted	8/9/22		Planner Edit		1104					NAPA C & D	Accad, Angelito	######		Acevedo, Dominic	2		6) Number of Attendees who visited 6 locations: 0	0
9	1	2	4	NAPA C & D	Abell, Ryan	8/9/22 0:00	36N7QN3PMVQ	Accepted	8/9/22		OnArrival	8/9/22	1204					SONOMA C & D	Accad, Angelito	######		Acevedo, Jose	2		7) Number of Attendees who visited 7 locations: 0	0
10	1	3	4	NAPA C & D	Abell, Ryan	8/9/22 0:00	36N7QN3PMVQ	Accepted	8/9/22		OnArrival	8/9/22	1304					GRAND BALLROOM A	Accad, Angelito	######		Aceves, Danny	1
11	1	4	4	NAPA C & D	Abell, Ryan	8/9/22 0:00	36N7QN3PMVQ	Accepted	8/9/22		OnArrival	8/9/22	1404					GRAND BALLROOM B	Acevedo, Dominic	######		Acosta, Jose	3
12	1	6	4	NAPA C & D	Abell, Ryan	8/9/22 0:00	36N7QN3PMVQ	Accepted	8/9/22		OnArrival	8/9/22	1604					NAPA A & B	Acevedo, Dominic	######		Acosta, Roberto	1
13	1	7	4	NAPA C & D	Abell, Ryan	8/9/22 0:00	36N7QN3PMVQ	Accepted	8/9/22		OnArrival	8/9/22	1704					GRAND BALLROOM A	Acevedo, Jose	######		Acosta, Ruben	1
14	1	1	11	GRAND BALLROOM A	Abeyta, Raymond	8/9/22 0:00	5LN64ZC4FLL	Accepted	8/9/22		OnArrival	8/9/22	1111					SHOWROOM	Acevedo, Jose	######		Adame, Kyle	2
15	1	2	11	GRAND BALLROOM A	Abeyta, Raymond	8/9/22 0:00	5LN64ZC4FLL	Accepted	8/9/22		OnArrival	8/9/22	1211					GRAND BALLROOM A	Aceves, Danny	######		Adams, Brad	1
16	1	3	11	GRAND BALLROOM A	Abeyta, Raymond	8/9/22 0:00	5LN64ZC4FLL	Accepted	8/9/22		OnArrival	8/9/22	1311					GRAND BALLROOM A	Acosta, Jose	######		Adams, Randy	2
17	1	4	11	GRAND BALLROOM A	Abeyta, Raymond	8/9/22 0:00	5LN64ZC4FLL	Accepted	8/9/22		OnArrival	8/9/22	1411					NAPA C & D	Acosta, Jose	######		Adams, Richard	2
18	1	5	11	GRAND BALLROOM A	Abeyta, Raymond	8/9/22 0:00	5LN64ZC4FLL	Accepted	8/9/22		OnArrival	8/9/22	1511					SONOMA C & D	Acosta, Jose	######		0
19	1	6	11	GRAND BALLROOM A	Abeyta, Raymond	8/9/22 0:00	5LN64ZC4FLL	Accepted	8/9/22		OnArrival	8/9/22	1611					GRAND BALLROOM A	Acosta, Roberto	######
20	1	1	4	NAPA C & D	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival		1104					SONOMA C & D	Acosta, Ruben	######
21	1	1	10	SONOMA C & D	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1110					GRAND BALLROOM B	Adame, Kyle	######
22	1	2	4	NAPA C & D	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1204					SHOWROOM	Adame, Kyle	######
23	1	3	4	NAPA C & D	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1304					GRAND BALLROOM A	Adams, Brad	######
24	1	4	11	GRAND BALLROOM A	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1411					GRAND BALLROOM B	Adams, Randy	######
25	1	5	11	GRAND BALLROOM A	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1511					NAPA A & B	Adams, Randy	######
26	1	6	11	GRAND BALLROOM A	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1611					SONOMA C & D	Adams, Richard	######
27	1	7	11	GRAND BALLROOM A	Accad, Angelito	8/9/22 0:00	3FNT5242DTN	Accepted	8/9/22		OnArrival	8/9/22	1711					SONOMA A	Adams, Richard	######
28	1	6	2	GRAND BALLROOM B	Acevedo, Dominic	8/9/22 0:00	7SN6NK9FK8X	Accepted	8/9/22		OnArrival	8/9/22	1602					0	0	0
29	1	7	8	NAPA A & B	Acevedo, Dominic	8/9/22 0:00	7SN6NK9FK8X	Accepted	8/9/22		OnArrival	8/9/22	1708
30	1	1	11	GRAND BALLROOM A	Acevedo, Jose	8/9/22 0:00	3TNLS2JZWBF	Accepted	8/9/22		OnArrival	8/9/22	1111
31	1	2	11	GRAND BALLROOM A	Acevedo, Jose	8/9/22 0:00	3TNLS2JZWBF	Accepted	8/9/22		OnArrival	8/9/22	1211
32	1	3	6	SHOWROOM	Acevedo, Jose	8/9/22 0:00	3TNLS2JZWBF	Accepted	8/9/22		OnArrival	8/9/22	1306
33	1	4	6	SHOWROOM	Acevedo, Jose	8/9/22 0:00	3TNLS2JZWBF	Accepted	8/9/22		OnArrival	8/9/22	1406
34	1	5	6	SHOWROOM	Acevedo, Jose	8/9/22 0:00	3TNLS2JZWBF	Accepted	8/9/22		OnArrival	8/9/22	1506
35	1	6	6	SHOWROOM	Acevedo, Jose	8/9/22 0:00	3TNLS2JZWBF	Accepted	8/9/22		OnArrival	8/9/22	1606
36	1	1	11	GRAND BALLROOM A	Aceves, Danny	8/9/22 0:00	SHNR8B4YR8H	Accepted	8/9/22		OnArrival	8/9/22	1111
37	1	2	11	GRAND BALLROOM A	Aceves, Danny	8/9/22 0:00	SHNR8B4YR8H	Accepted	8/9/22		OnArrival	8/9/22	1211
38	1	3	11	GRAND BALLROOM A	Aceves, Danny	8/9/22 0:00	SHNR8B4YR8H	Accepted	8/9/22		OnArrival	8/9/22	1311
39	1	4	11	GRAND BALLROOM A	Aceves, Danny	8/9/22 0:00	SHNR8B4YR8H	Accepted	8/9/22		OnArrival	8/9/22	1411
40	1	5	11	GRAND BALLROOM A	Aceves, Danny	8/9/22 0:00	SHNR8B4YR8H	Accepted	8/9/22		OnArrival	8/9/22	1511
41	1	6	11	GRAND BALLROOM A	Aceves, Danny	8/9/22 0:00	SHNR8B4YR8H	Accepted	8/9/22		OnArrival	8/9/22	1611
42	1	1	11	GRAND BALLROOM A	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1111
43	1	2	4	NAPA C & D	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1204
44	1	3	4	NAPA C & D	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1304
45	1	4	4	NAPA C & D	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1404
46	1	5	4	NAPA C & D	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1504
47	1	6	10	SONOMA C & D	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1610
48	1	7	11	GRAND BALLROOM A	Acosta, Jose	8/9/22 0:00	F7NBW4F5F32	Accepted	8/9/22		OnArrival	8/9/22	1711
49	1	1	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1111
50	1	2	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1211
51	1	3	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1311
52	1	4	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1411
53	1	5	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1511
54	1	6	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1611
55	1	7	11	GRAND BALLROOM A	Acosta, Roberto	8/9/22 0:00	X9NVGNP924G	Accepted	8/9/22		OnArrival	8/9/22	1711
56	1	2	10	SONOMA C & D	Acosta, Ruben	8/9/22 0:00	T7N69SKRYG2	Accepted	8/9/22		OnArrival	8/9/22	1210
57	1	3	10	SONOMA C & D	Acosta, Ruben	8/9/22 0:00	T7N69SKRYG2	Accepted	8/9/22		OnArrival	8/9/22	1310
58	1	4	10	SONOMA C & D	Acosta, Ruben	8/9/22 0:00	T7N69SKRYG2	Accepted	8/9/22		OnArrival	8/9/22	1410
59	1	5	10	SONOMA C & D	Acosta, Ruben	8/9/22 0:00	T7N69SKRYG2	Accepted	8/9/22		OnArrival	8/9/22	1510
60	1	6	10	SONOMA C & D	Acosta, Ruben	8/9/22 0:00	T7N69SKRYG2	Accepted	8/9/22		OnArrival	8/9/22	1610
61	1	7	10	SONOMA C & D	Acosta, Ruben	8/9/22 0:00	T7N69SKRYG2	Accepted	8/9/22		OnArrival	8/9/22	1710
62	1	3	2	GRAND BALLROOM B	Adame, Kyle	8/9/22 0:00	39NZLQ44BZ8	Accepted	8/9/22		OnArrival	8/9/22	1302
63	1	5	6	SHOWROOM	Adame, Kyle	8/9/22 0:00	39NZLQ44BZ8	Accepted	8/9/22		OnArrival	8/9/22	1506
64	1	3	11	GRAND BALLROOM A	Adams, Brad	8/9/22 0:00	FWNR74N8TL9	Accepted	8/9/22		OnArrival	8/9/22	1311
65	1	2	2	GRAND BALLROOM B	Adams, Randy	8/9/22 0:00	BJNLCQHR3CC	Accepted	8/9/22		OnArrival	8/9/22	1202
66	1	3	2	GRAND BALLROOM B	Adams, Randy	8/9/22 0:00	BJNLCQHR3CC	Accepted	8/9/22		OnArrival	8/9/22	1302
67	1	4	8	NAPA A & B	Adams, Randy	8/9/22 0:00	BJNLCQHR3CC	Accepted	8/9/22		OnArrival	8/9/22	1408
68	1	2	10	SONOMA C & D	Adams, Richard	8/9/22 0:00	8PNT5LT2YP9	Accepted	8/9/22		OnArrival	8/9/22	1210
69	1	3	10	SONOMA C & D	Adams, Richard	8/9/22 0:00	8PNT5LT2YP9	Accepted	8/9/22		OnArrival	8/9/22	1310
70	1	4	10	SONOMA C & D	Adams, Richard	8/9/22 0:00	8PNT5LT2YP9	Accepted	8/9/22		OnArrival	8/9/22	1410
71	1	5	10	SONOMA C & D	Adams, Richard	8/9/22 0:00	8PNT5LT2YP9	Accepted	8/9/22		OnArrival	8/9/22	1510
72	1	6	3	SONOMA A	Adams, Richard	8/9/22 0:00	8PNT5LT2YP9	Accepted	8/9/22		OnArrival	8/9/22	1603
73	1	7	3	SONOMA A	Adams, Richard	8/9/22 0:00	8PNT5LT2YP9	Accepted	8/9/22		OnArrival	8/9/22	1703
74
Sheet1

Cell Formulas
Range	Formula
V2:V18	V2	=UNIQUE(S:S)
R3:T28	R3	=UNIQUE(D:F)
L2	L2	=DATE(2022,8,9)+TIME(8,23,57)
L3	L3	=DATE(2022,8,9)+TIME(9,21,2)
L4	L4	=DATE(2022,8,9)+TIME(10,34,7)
L5	L5	=DATE(2022,8,9)+TIME(11,34,42)
L6	L6	=DATE(2022,8,9)+TIME(13,50,35)
L7	L7	=DATE(2022,8,9)+TIME(14,53,25)
Z3:Z9	Z3	=COUNTIF(W:W,LEFT(Y3,1))
W4:W17	W4	=COUNTIF(S:S,V4)
L9	L9	=DATE(2022,8,9)+TIME(9,29,23)
L10	L10	=DATE(2022,8,9)+TIME(10,32,27)
L11	L11	=DATE(2022,8,9)+TIME(11,32,13)
L12	L12	=DATE(2022,8,9)+TIME(14,51,32)
L13	L13	=DATE(2022,8,9)+TIME(15,52,19)
L14	L14	=DATE(2022,8,9)+TIME(8,22,36)
L15	L15	=DATE(2022,8,9)+TIME(9,20,53)
L16	L16	=DATE(2022,8,9)+TIME(10,32,29)
L17	L17	=DATE(2022,8,9)+TIME(11,32,12)
L18	L18	=DATE(2022,8,9)+TIME(13,49,44)
L19	L19	=DATE(2022,8,9)+TIME(14,50,8)
F2:F73	F2	=INT(I2)
I2	I2	=DATE(2022,8,9)+TIME(7,17,9)
I3	I3	=DATE(2022,8,9)+TIME(8,31,27)
I4	I4	=DATE(2022,8,9)+TIME(9,33,23)
I5	I5	=DATE(2022,8,9)+TIME(10,45,2)
I6	I6	=DATE(2022,8,9)+TIME(12,51,58)
I7	I7	=DATE(2022,8,9)+TIME(13,58,2)
I8	I8	=DATE(2022,8,9)+TIME(7,31,19)
I9	I9	=DATE(2022,8,9)+TIME(8,30,15)
I10	I10	=DATE(2022,8,9)+TIME(9,42,30)
I11	I11	=DATE(2022,8,9)+TIME(10,39,30)
I12	I12	=DATE(2022,8,9)+TIME(13,59,15)
I13	I13	=DATE(2022,8,9)+TIME(14,57,45)
I14	I14	=DATE(2022,8,9)+TIME(7,16,3)
I15	I15	=DATE(2022,8,9)+TIME(8,31,10)
I16	I16	=DATE(2022,8,9)+TIME(9,39,41)
I17	I17	=DATE(2022,8,9)+TIME(10,42,49)
I18	I18	=DATE(2022,8,9)+TIME(12,59,4)
I19	I19	=DATE(2022,8,9)+TIME(14,0,15)
I20	I20	=DATE(2022,8,9)+TIME(7,36,19)
I21	I21	=DATE(2022,8,9)+TIME(7,35,31)
I22	I22	=DATE(2022,8,9)+TIME(8,30,51)
I23	I23	=DATE(2022,8,9)+TIME(9,38,17)
I24	I24	=DATE(2022,8,9)+TIME(10,38,29)
I25	I25	=DATE(2022,8,9)+TIME(12,55,45)
I26	I26	=DATE(2022,8,9)+TIME(13,57,56)
I27	I27	=DATE(2022,8,9)+TIME(15,0,21)
I28	I28	=DATE(2022,8,9)+TIME(13,56,42)
I29	I29	=DATE(2022,8,9)+TIME(15,2,47)
I30	I30	=DATE(2022,8,9)+TIME(7,24,43)
I31	I31	=DATE(2022,8,9)+TIME(8,31,36)
I32	I32	=DATE(2022,8,9)+TIME(9,29,49)
I33	I33	=DATE(2022,8,9)+TIME(10,42,56)
I34	I34	=DATE(2022,8,9)+TIME(12,47,6)
I35	I35	=DATE(2022,8,9)+TIME(13,56,59)
I36	I36	=DATE(2022,8,9)+TIME(7,16,14)
I37	I37	=DATE(2022,8,9)+TIME(8,28,38)
I38	I38	=DATE(2022,8,9)+TIME(9,29,18)
I39	I39	=DATE(2022,8,9)+TIME(10,37,51)
I40	I40	=DATE(2022,8,9)+TIME(12,51,42)
I41	I41	=DATE(2022,8,9)+TIME(13,57,47)
I42	I42	=DATE(2022,8,9)+TIME(7,16,19)
I43	I43	=DATE(2022,8,9)+TIME(8,32,33)
I44	I44	=DATE(2022,8,9)+TIME(9,39,5)
I45	I45	=DATE(2022,8,9)+TIME(10,39,32)
I46	I46	=DATE(2022,8,9)+TIME(12,59,38)
I47	I47	=DATE(2022,8,9)+TIME(13,51,56)
I48	I48	=DATE(2022,8,9)+TIME(15,1,28)
I49	I49	=DATE(2022,8,9)+TIME(7,16,59)
I50	I50	=DATE(2022,8,9)+TIME(8,30,6)
I51	I51	=DATE(2022,8,9)+TIME(9,34,44)
I52	I52	=DATE(2022,8,9)+TIME(10,41,26)
I53	I53	=DATE(2022,8,9)+TIME(12,54,38)
I54	I54	=DATE(2022,8,9)+TIME(13,59,51)
I55	I55	=DATE(2022,8,9)+TIME(14,59,56)
I56	I56	=DATE(2022,8,9)+TIME(8,31,35)
I57	I57	=DATE(2022,8,9)+TIME(9,37,16)
I58	I58	=DATE(2022,8,9)+TIME(10,40,29)
I59	I59	=DATE(2022,8,9)+TIME(12,59,41)
I60	I60	=DATE(2022,8,9)+TIME(13,57,38)
I61	I61	=DATE(2022,8,9)+TIME(14,58,11)
I62	I62	=DATE(2022,8,9)+TIME(9,43,57)
I63	I63	=DATE(2022,8,9)+TIME(12,58,34)
I64	I64	=DATE(2022,8,9)+TIME(9,34,54)
I65	I65	=DATE(2022,8,9)+TIME(8,27,52)
I66	I66	=DATE(2022,8,9)+TIME(9,35,42)
I67	I67	=DATE(2022,8,9)+TIME(10,42,55)
I68	I68	=DATE(2022,8,9)+TIME(8,26,59)
I69	I69	=DATE(2022,8,9)+TIME(9,39,33)
I70	I70	=DATE(2022,8,9)+TIME(10,37,10)
I71	I71	=DATE(2022,8,9)+TIME(12,50,45)
I72	I72	=DATE(2022,8,9)+TIME(13,56,38)
I73	I73	=DATE(2022,8,9)+TIME(15,0,4)
L21	L21	=DATE(2022,8,9)+TIME(7,35,40)
L22	L22	=DATE(2022,8,9)+TIME(9,23,51)
L23	L23	=DATE(2022,8,9)+TIME(10,29,23)
L24	L24	=DATE(2022,8,9)+TIME(11,29,52)
L25	L25	=DATE(2022,8,9)+TIME(13,52,43)
L26	L26	=DATE(2022,8,9)+TIME(14,55,52)
L27	L27	=DATE(2022,8,9)+TIME(15,50,8)
L28	L28	=DATE(2022,8,9)+TIME(14,50,32)
L29	L29	=DATE(2022,8,9)+TIME(15,47,51)
L30	L30	=DATE(2022,8,9)+TIME(8,23,14)
L31	L31	=DATE(2022,8,9)+TIME(9,21,18)
L32	L32	=DATE(2022,8,9)+TIME(10,33,58)
L33	L33	=DATE(2022,8,9)+TIME(11,33,26)
L34	L34	=DATE(2022,8,9)+TIME(13,56,0)
L35	L35	=DATE(2022,8,9)+TIME(14,53,30)
L36	L36	=DATE(2022,8,9)+TIME(8,25,43)
L37	L37	=DATE(2022,8,9)+TIME(9,24,23)
L38	L38	=DATE(2022,8,9)+TIME(10,34,31)
L39	L39	=DATE(2022,8,9)+TIME(11,29,53)
L40	L40	=DATE(2022,8,9)+TIME(13,52,29)
L41	L41	=DATE(2022,8,9)+TIME(14,52,10)
L42	L42	=DATE(2022,8,9)+TIME(8,23,4)
L43	L43	=DATE(2022,8,9)+TIME(9,27,11)
L44	L44	=DATE(2022,8,9)+TIME(10,31,42)
L45	L45	=DATE(2022,8,9)+TIME(11,30,21)
L46	L46	=DATE(2022,8,9)+TIME(13,49,59)
L47	L47	=DATE(2022,8,9)+TIME(14,52,24)
L48	L48	=DATE(2022,8,9)+TIME(15,50,35)
L49	L49	=DATE(2022,8,9)+TIME(8,21,50)
L50	L50	=DATE(2022,8,9)+TIME(9,21,7)
L51	L51	=DATE(2022,8,9)+TIME(10,31,52)
L52	L52	=DATE(2022,8,9)+TIME(11,31,34)
L53	L53	=DATE(2022,8,9)+TIME(13,52,14)
L54	L54	=DATE(2022,8,9)+TIME(14,52,44)
L55	L55	=DATE(2022,8,9)+TIME(15,52,25)
L56	L56	=DATE(2022,8,9)+TIME(9,24,22)
L57	L57	=DATE(2022,8,9)+TIME(10,31,59)
L58	L58	=DATE(2022,8,9)+TIME(11,33,9)
L59	L59	=DATE(2022,8,9)+TIME(13,50,50)
L60	L60	=DATE(2022,8,9)+TIME(14,51,36)
L61	L61	=DATE(2022,8,9)+TIME(15,50,56)
L62	L62	=DATE(2022,8,9)+TIME(10,34,48)
L63	L63	=DATE(2022,8,9)+TIME(13,54,46)
L64	L64	=DATE(2022,8,9)+TIME(10,31,47)
L65	L65	=DATE(2022,8,9)+TIME(9,23,36)
L66	L66	=DATE(2022,8,9)+TIME(10,31,53)
L67	L67	=DATE(2022,8,9)+TIME(11,33,55)
L68	L68	=DATE(2022,8,9)+TIME(9,24,28)
L69	L69	=DATE(2022,8,9)+TIME(10,33,20)
L70	L70	=DATE(2022,8,9)+TIME(11,33,47)
L71	L71	=DATE(2022,8,9)+TIME(13,52,23)
L72	L72	=DATE(2022,8,9)+TIME(14,52,29)
L73	L73	=DATE(2022,8,9)+TIME(15,53,28)
Dynamic array formulas.

 

[johns_st]

Thank you, it worked excellently!

 

[etaf]

are you happy with the helpers , I wont be able to look again till next week now

 

[johns_st]

are you happy with the helpers , I wont be able to look again till next week now

The help you provided is what I needed. I was able to get the information exported for our presentation yesterday. Thank you again for your assistance!