How to count all unique values based on another column

[phillipc1]

Hello,

I am looking to be able to get a count of all unique values based on a date. I am having trouble trying to get the count to work as I have tried a couple solutions I looked up online but none seemed to work.

Essentially I want to populate column F in the first image. This column is to be populated by a unique count of PCs (Column C, Group, in the second image) by the date in column B.

Here are the formulas I have tried using but both return 0

=SUM(IF('Installed Units'!D:D='Daily Tracker'!B7,1/COUNTIFS('Installed Units'!C:C,'Installed Units'!C:C)))

=SUM(--(LEN(UNIQUE(FILTER('Installed Units'!$C:$C,'Installed Units'!$D:$D='Daily Tracker'!$B8,"")))>0))

 

[HighAndWilder]

Hello,

I am looking to be able to get a count of all unique values based on a date. I am having trouble trying to get the count to work as I have tried a couple solutions I looked up online but none seemed to work.

Essentially I want to populate column F in the first image. This column is to be populated by a unique count of PCs (Column C, Group, in the second image) by the date in column B.

Here are the formulas I have tried using but both return 0

=SUM(IF('Installed Units'!D:D='Daily Tracker'!B7,1/COUNTIFS('Installed Units'!C:C,'Installed Units'!C:C)))

=SUM(--(LEN(UNIQUE(FILTER('Installed Units'!$C:$C,'Installed Units'!$D:$D='Daily Tracker'!$B8,"")))>0))

View attachment 101659
View attachment 101660

Can you please use XL2BB to submit your data so that we can use it to provide a solution?

Thanks

 

[phillipc1]

RITA Install Daily Monthly Rate .xlsx
	A	B	C	D	E	F	G
1	Current Installed Count:		3985		Green = 90%+		11/8/2023
2	Planned Installs:		7500
3	Percent Complete:		53%		ROLLING AVG GOAL %
4					57%
5	DAILY INFO			SHORT RANGE GOAL: 2/28/2024		PC INFO
6	Day	Date	Daily Actual Installs Completed	Short Range Daily Goal	% of Short Range Daily Goal Achieved	PCs Served	Avg Installs Per PC That Day
7	Wednesday	11/8/2023	3	30	10%
8	Tuesday	11/7/2023	12	30	40%
9	Monday	11/6/2023	31	30	103%
10	Sunday	11/5/2023	0	0
11	Saturday	11/4/2023	10	0
12	Friday	11/3/2023	19	30	63%
13	Thursday	11/2/2023	17	30	57%
14	Wednesday	11/1/2023	36	30	120%
15	Tuesday	10/31/2023	27	30	90%
16	Monday	10/30/2023	19	30	63%
17	Sunday	10/29/2023	0	0
18	Saturday	10/28/2023	7	0
19	Friday	10/27/2023	16	30	53%
20	Thursday	10/26/2023	21	30	70%
21	Wednesday	10/25/2023	16	30	53%
22	Tuesday	10/24/2023	14	30	47%
23	Monday	10/23/2023	12	30	40%
24	Sunday	10/22/2023	0	0
25	Saturday	10/21/2023	2	0
26	Friday	10/20/2023	6	30	20%
27	Thursday	10/19/2023	18	30	60%
28	Wednesday	10/18/2023	18	30	60%
29	Tuesday	10/17/2023	13	30	43%
30	Monday	10/16/2023	15	30	50%
31	Sunday	10/15/2023	0	0
32	Saturday	10/14/2023	8	0
33	Friday	10/13/2023	11	30	37%
34	Thursday	10/12/2023	11	30	37%
35	Wednesday	10/11/2023	16	30	53%
36	Tuesday	10/10/2023	28	30	93%
Daily Tracker

Cell Formulas
Range	Formula
C1	C1	=SUMPRODUCT(--(Table1[Device]<>""))
G1	G1	=TODAY()
C3	C3	=C1/C2
E4	E4	=AVERAGE(E7:E36)
A7:A36	A7	=TEXT(B7,"DDDD")
B7	B7	=$G$1
C7:C36	C7	=COUNTIF('Installed Units'!$D:$D,'Daily Tracker'!$B7)
D7:D36	D7	=IF(A7="Saturday",0,IF(A7="Sunday",0,30))
E7:E36	E7	=IF(A7="Saturday","",IF(A7="Sunday","",C7/D7))
B8	B8	=$G$1-1
B9	B9	=$G$1-2
B10	B10	=$G$1-3
B11	B11	=$G$1-4
B12	B12	=$G$1-5
B13	B13	=$G$1-6
B14	B14	=$G$1-7
B15	B15	=$G$1-8
B16	B16	=$G$1-9
B17	B17	=$G$1-10
B18	B18	=$G$1-11
B19	B19	=$G$1-12
B20	B20	=$G$1-13
B21	B21	=$G$1-14
B22	B22	=$G$1-15
B23	B23	=$G$1-16
B24	B24	=$G$1-17
B25	B25	=$G$1-18
B26	B26	=$G$1-19
B27	B27	=$G$1-20
B28	B28	=$G$1-21
B29	B29	=$G$1-22
B30	B30	=$G$1-23
B31	B31	=$G$1-24
B32	B32	=$G$1-25
B33	B33	=$G$1-26
B34	B34	=$G$1-27
B35	B35	=$G$1-28
B36	B36	=$G$1-29
G7:G36	G7	=IFERROR(C7/F7,"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F3	Cell	contains a blank value	text	NO
E4	Cell Value	<0.898	text	NO
E4	Cell Value	>0.899	text	NO
E1:E2,I35,K35,E4:E1048576	Cell	contains a blank value	text	NO

RITA Install Daily Monthly Rate .xlsx
	A	B	C	D
3442	802822	QM40829221	PC0029	10/28/2023
3443	10154576	QM40829247	PC0029	10/28/2023
3444	10182566	QM40829306	PC0633	10/28/2023
3445	10263500	QM40829312	PC0633	10/28/2023
3446	10164126	QM40829347	PC0588	10/28/2023
3447	765370	QM40829378	PC0588	10/28/2023
3448	10272258	QM40829515	PC0633	10/28/2023
3449	90233	QM00077897	PC7053	10/27/2023
3450	10066859	QM00080047	PC1629	10/27/2023
3451	COM6986	QM00080156	PC1629	10/27/2023
3452	10484842	QM00083508	PC0150	10/27/2023
3453	10339508	QM00085307	PC0227	10/27/2023
3454	10462278	QM00085581	PC0227	10/27/2023
3455	10479098	QM00086713	PC1391	10/27/2023
3456	10071816	QM00088813	PC1629	10/27/2023
3457	716212	QM40829049	PC0246	10/27/2023
3458	CBT1782	QM40829251	PC1663	10/27/2023
3459	10380230	QM40829301	PC1033	10/27/2023
3460	10095532	QM40829328	PC0071	10/27/2023
3461	908894	QM40829398	PC1033	10/27/2023
3462	960773	QM40829408	PC0071	10/27/2023
3463	10175022	QM40829443	PC1284	10/27/2023
3464	10233468	QM40829606	PC1033	10/27/2023
3465	10194243	QM00022135	PC1268	10/27/2022
3466	10366196	QM00034388	PC0241	10/27/2022
3467	11004325	QM00074689	PC1968	10/26/2023
3468	MLOC69	QM00078387	PC7134	10/26/2023
3469	MLOC106	QM00078707	PC7134	10/26/2023
3470	10247881	QM00080149	PC0150	10/26/2023
3471	10082669	QM00083345	PC0263	10/26/2023
3472	992157	QM00083435	PC1196	10/26/2023
3473	10095912	QM00083457	PC0263	10/26/2023
3474	1003098	QM00083635	PC1835	10/26/2023
3475	70044010	QM00085175	PC7009	10/26/2023
3476	622785	QM00085604	PC1392	10/26/2023
3477	10202313	QM00086482	PC1196	10/26/2023
3478	10164371	QM00086818	PC1042	10/26/2023
3479	10013253	QM40817553	PC0573	10/26/2023
3480	10517969	QM40829125	PC0328	10/26/2023
3481	10201270	QM40829232	PC0499	10/26/2023
3482	10357751	QM40829334	PC1303	10/26/2023
3483	1058691	QM40829418	PC0499	10/26/2023
3484	10486549	QM40829492	PC0499	10/26/2023
3485	760765	QM40829585	PC1065	10/26/2023
3486	773645	QM40830282	PC0573	10/26/2023
3487	10362288	QM40830492	PC0573	10/26/2023
3488	563329	QM00034362	PC1630	10/26/2022
3489	MLOC132	QM00077976	PC7134	10/25/2023
3490	10222321	QM00080180	PC1196	10/25/2023
3491	10415720	QM00080579	PC0280	10/25/2023
3492	10263352	QM00083503	PC0150	10/25/2023
3493	10490579	QM00084545	PC5001	10/25/2023
3494	932815	QM00085691	PC1929	10/25/2023
3495	10415675	QM40829071	PC0499	10/25/2023
3496	10629896	QM40829142	PC1015	10/25/2023
3497	10002751	QM40829203	PC0055	10/25/2023
3498	10484658	QM40829259	PC1196	10/25/2023
3499	1001057	QM40829428	PC0650	10/25/2023
3500	10048216	QM40829446	PC0006	10/25/2023
3501	10186451	QM40829449	PC0499	10/25/2023
3502	10552720	QM40829455	PC0499	10/25/2023
3503	10139542	QM40829458	PC0351	10/25/2023
3504	10342910	QM40829519	PC0499	10/25/2023
3505	CHR229	QM00029938	PC1630	10/25/2022
3506	761738	QM00034302	PC0331	10/25/2022
3507	CHR236	QM00034750	PC1433	10/25/2022
3508	862838	QM00034857	PC1630	10/25/2022
3509	CHR224	QM00034858	PC1630	10/25/2022
3510	10227583	QM00035863	PC1630	10/25/2022
3511	10484818	QM00080081	PC0150	10/24/2023
3512	IAS16	QM00083572	PC1196	10/24/2023
3513	10188728	QM00084553	PC1196	10/24/2023
Installed Units

Cell Formulas
Range	Formula
A3442	A3442	=IFERROR(TEXTAFTER('Raw Data'!C3746,"-"),"")
B3442	B3442	=IFERROR(IF('Raw Data'!A3746=0,"",'Raw Data'!A3746),"")
C3442	C3442	=IFERROR(TEXTBEFORE('Raw Data'!C3746,"-"),"")
D3442	D3442	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3746,",",2)),"m/d/yyyy"),"")
A3443,A3499	A3443	=IFERROR(TEXTAFTER('Raw Data'!C3750,"-"),"")
B3443,B3499	B3443	=IFERROR(IF('Raw Data'!A3750=0,"",'Raw Data'!A3750),"")
C3443,C3499	C3443	=IFERROR(TEXTBEFORE('Raw Data'!C3750,"-"),"")
D3443,D3499	D3443	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3750,",",2)),"m/d/yyyy"),"")
A3444	A3444	=IFERROR(TEXTAFTER('Raw Data'!C3768,"-"),"")
B3444	B3444	=IFERROR(IF('Raw Data'!A3768=0,"",'Raw Data'!A3768),"")
C3444	C3444	=IFERROR(TEXTBEFORE('Raw Data'!C3768,"-"),"")
D3444	D3444	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3768,",",2)),"m/d/yyyy"),"")
A3445	A3445	=IFERROR(TEXTAFTER('Raw Data'!C3771,"-"),"")
B3445	B3445	=IFERROR(IF('Raw Data'!A3771=0,"",'Raw Data'!A3771),"")
C3445	C3445	=IFERROR(TEXTBEFORE('Raw Data'!C3771,"-"),"")
D3445	D3445	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3771,",",2)),"m/d/yyyy"),"")
A3446	A3446	=IFERROR(TEXTAFTER('Raw Data'!C3779,"-"),"")
B3446	B3446	=IFERROR(IF('Raw Data'!A3779=0,"",'Raw Data'!A3779),"")
C3446	C3446	=IFERROR(TEXTBEFORE('Raw Data'!C3779,"-"),"")
D3446	D3446	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3779,",",2)),"m/d/yyyy"),"")
A3447	A3447	=IFERROR(TEXTAFTER('Raw Data'!C3790,"-"),"")
B3447	B3447	=IFERROR(IF('Raw Data'!A3790=0,"",'Raw Data'!A3790),"")
C3447	C3447	=IFERROR(TEXTBEFORE('Raw Data'!C3790,"-"),"")
D3447	D3447	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3790,",",2)),"m/d/yyyy"),"")
A3448	A3448	=IFERROR(TEXTAFTER('Raw Data'!C3826,"-"),"")
B3448	B3448	=IFERROR(IF('Raw Data'!A3826=0,"",'Raw Data'!A3826),"")
C3448	C3448	=IFERROR(TEXTBEFORE('Raw Data'!C3826,"-"),"")
D3448	D3448	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3826,",",2)),"m/d/yyyy"),"")
A3449	A3449	=IFERROR(TEXTAFTER('Raw Data'!C2254,"-"),"")
B3449	B3449	=IFERROR(IF('Raw Data'!A2254=0,"",'Raw Data'!A2254),"")
C3449	C3449	=IFERROR(TEXTBEFORE('Raw Data'!C2254,"-"),"")
D3449	D3449	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2254,",",2)),"m/d/yyyy"),"")
A3450	A3450	=IFERROR(TEXTAFTER('Raw Data'!C2431,"-"),"")
B3450	B3450	=IFERROR(IF('Raw Data'!A2431=0,"",'Raw Data'!A2431),"")
C3450	C3450	=IFERROR(TEXTBEFORE('Raw Data'!C2431,"-"),"")
D3450	D3450	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2431,",",2)),"m/d/yyyy"),"")
A3451	A3451	=IFERROR(TEXTAFTER('Raw Data'!C2436,"-"),"")
B3451	B3451	=IFERROR(IF('Raw Data'!A2436=0,"",'Raw Data'!A2436),"")
C3451	C3451	=IFERROR(TEXTBEFORE('Raw Data'!C2436,"-"),"")
D3451	D3451	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2436,",",2)),"m/d/yyyy"),"")
A3452	A3452	=IFERROR(TEXTAFTER('Raw Data'!C2525,"-"),"")
B3452	B3452	=IFERROR(IF('Raw Data'!A2525=0,"",'Raw Data'!A2525),"")
C3452	C3452	=IFERROR(TEXTBEFORE('Raw Data'!C2525,"-"),"")
D3452	D3452	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2525,",",2)),"m/d/yyyy"),"")
A3453	A3453	=IFERROR(TEXTAFTER('Raw Data'!C2698,"-"),"")
B3453	B3453	=IFERROR(IF('Raw Data'!A2698=0,"",'Raw Data'!A2698),"")
C3453	C3453	=IFERROR(TEXTBEFORE('Raw Data'!C2698,"-"),"")
D3453	D3453	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2698,",",2)),"m/d/yyyy"),"")
A3454	A3454	=IFERROR(TEXTAFTER('Raw Data'!C2784,"-"),"")
B3454	B3454	=IFERROR(IF('Raw Data'!A2784=0,"",'Raw Data'!A2784),"")
C3454	C3454	=IFERROR(TEXTBEFORE('Raw Data'!C2784,"-"),"")
D3454	D3454	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2784,",",2)),"m/d/yyyy"),"")
A3455	A3455	=IFERROR(TEXTAFTER('Raw Data'!C2948,"-"),"")
B3455	B3455	=IFERROR(IF('Raw Data'!A2948=0,"",'Raw Data'!A2948),"")
C3455	C3455	=IFERROR(TEXTBEFORE('Raw Data'!C2948,"-"),"")
D3455	D3455	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2948,",",2)),"m/d/yyyy"),"")
A3456	A3456	=IFERROR(TEXTAFTER('Raw Data'!C3078,"-"),"")
B3456	B3456	=IFERROR(IF('Raw Data'!A3078=0,"",'Raw Data'!A3078),"")
C3456	C3456	=IFERROR(TEXTBEFORE('Raw Data'!C3078,"-"),"")
D3456	D3456	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3078,",",2)),"m/d/yyyy"),"")
A3457	A3457	=IFERROR(TEXTAFTER('Raw Data'!C3716,"-"),"")
B3457	B3457	=IFERROR(IF('Raw Data'!A3716=0,"",'Raw Data'!A3716),"")
C3457	C3457	=IFERROR(TEXTBEFORE('Raw Data'!C3716,"-"),"")
D3457	D3457	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3716,",",2)),"m/d/yyyy"),"")
A3458	A3458	=IFERROR(TEXTAFTER('Raw Data'!C3751,"-"),"")
B3458	B3458	=IFERROR(IF('Raw Data'!A3751=0,"",'Raw Data'!A3751),"")
C3458	C3458	=IFERROR(TEXTBEFORE('Raw Data'!C3751,"-"),"")
D3458	D3458	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3751,",",2)),"m/d/yyyy"),"")
A3459	A3459	=IFERROR(TEXTAFTER('Raw Data'!C3765,"-"),"")
B3459	B3459	=IFERROR(IF('Raw Data'!A3765=0,"",'Raw Data'!A3765),"")
C3459	C3459	=IFERROR(TEXTBEFORE('Raw Data'!C3765,"-"),"")
D3459	D3459	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3765,",",2)),"m/d/yyyy"),"")
A3460	A3460	=IFERROR(TEXTAFTER('Raw Data'!C3775,"-"),"")
B3460	B3460	=IFERROR(IF('Raw Data'!A3775=0,"",'Raw Data'!A3775),"")
C3460	C3460	=IFERROR(TEXTBEFORE('Raw Data'!C3775,"-"),"")
D3460	D3460	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3775,",",2)),"m/d/yyyy"),"")
A3461	A3461	=IFERROR(TEXTAFTER('Raw Data'!C3796,"-"),"")
B3461	B3461	=IFERROR(IF('Raw Data'!A3796=0,"",'Raw Data'!A3796),"")
C3461	C3461	=IFERROR(TEXTBEFORE('Raw Data'!C3796,"-"),"")
D3461	D3461	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3796,",",2)),"m/d/yyyy"),"")
A3462	A3462	=IFERROR(TEXTAFTER('Raw Data'!C3798,"-"),"")
B3462	B3462	=IFERROR(IF('Raw Data'!A3798=0,"",'Raw Data'!A3798),"")
C3462	C3462	=IFERROR(TEXTBEFORE('Raw Data'!C3798,"-"),"")
D3462	D3462	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3798,",",2)),"m/d/yyyy"),"")
A3463	A3463	=IFERROR(TEXTAFTER('Raw Data'!C3807,"-"),"")
B3463	B3463	=IFERROR(IF('Raw Data'!A3807=0,"",'Raw Data'!A3807),"")
C3463	C3463	=IFERROR(TEXTBEFORE('Raw Data'!C3807,"-"),"")
D3463	D3463	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3807,",",2)),"m/d/yyyy"),"")
A3464	A3464	=IFERROR(TEXTAFTER('Raw Data'!C3840,"-"),"")
B3464	B3464	=IFERROR(IF('Raw Data'!A3840=0,"",'Raw Data'!A3840),"")
C3464	C3464	=IFERROR(TEXTBEFORE('Raw Data'!C3840,"-"),"")
D3464	D3464	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3840,",",2)),"m/d/yyyy"),"")
A3465	A3465	=IFERROR(TEXTAFTER('Raw Data'!C702,"-"),"")
B3465	B3465	=IFERROR(IF('Raw Data'!A702=0,"",'Raw Data'!A702),"")
C3465	C3465	=IFERROR(TEXTBEFORE('Raw Data'!C702,"-"),"")
D3465	D3465	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G702,",",2)),"m/d/yyyy"),"")
A3466	A3466	=IFERROR(TEXTAFTER('Raw Data'!C973,"-"),"")
B3466	B3466	=IFERROR(IF('Raw Data'!A973=0,"",'Raw Data'!A973),"")
C3466	C3466	=IFERROR(TEXTBEFORE('Raw Data'!C973,"-"),"")
D3466	D3466	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G973,",",2)),"m/d/yyyy"),"")
A3467	A3467	=IFERROR(TEXTAFTER('Raw Data'!C2111,"-"),"")
B3467	B3467	=IFERROR(IF('Raw Data'!A2111=0,"",'Raw Data'!A2111),"")
C3467	C3467	=IFERROR(TEXTBEFORE('Raw Data'!C2111,"-"),"")
D3467	D3467	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2111,",",2)),"m/d/yyyy"),"")
A3468	A3468	=IFERROR(TEXTAFTER('Raw Data'!C2347,"-"),"")
B3468	B3468	=IFERROR(IF('Raw Data'!A2347=0,"",'Raw Data'!A2347),"")
C3468	C3468	=IFERROR(TEXTBEFORE('Raw Data'!C2347,"-"),"")
D3468	D3468	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2347,",",2)),"m/d/yyyy"),"")
A3469	A3469	=IFERROR(TEXTAFTER('Raw Data'!C2384,"-"),"")
B3469	B3469	=IFERROR(IF('Raw Data'!A2384=0,"",'Raw Data'!A2384),"")
C3469	C3469	=IFERROR(TEXTBEFORE('Raw Data'!C2384,"-"),"")
D3469	D3469	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2384,",",2)),"m/d/yyyy"),"")
A3470	A3470	=IFERROR(TEXTAFTER('Raw Data'!C2435,"-"),"")
B3470	B3470	=IFERROR(IF('Raw Data'!A2435=0,"",'Raw Data'!A2435),"")
C3470	C3470	=IFERROR(TEXTBEFORE('Raw Data'!C2435,"-"),"")
D3470	D3470	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2435,",",2)),"m/d/yyyy"),"")
A3471	A3471	=IFERROR(TEXTAFTER('Raw Data'!C2504,"-"),"")
B3471	B3471	=IFERROR(IF('Raw Data'!A2504=0,"",'Raw Data'!A2504),"")
C3471	C3471	=IFERROR(TEXTBEFORE('Raw Data'!C2504,"-"),"")
D3471	D3471	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2504,",",2)),"m/d/yyyy"),"")
A3472	A3472	=IFERROR(TEXTAFTER('Raw Data'!C2515,"-"),"")
B3472	B3472	=IFERROR(IF('Raw Data'!A2515=0,"",'Raw Data'!A2515),"")
C3472	C3472	=IFERROR(TEXTBEFORE('Raw Data'!C2515,"-"),"")
D3472	D3472	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2515,",",2)),"m/d/yyyy"),"")
A3473	A3473	=IFERROR(TEXTAFTER('Raw Data'!C2518,"-"),"")
B3473	B3473	=IFERROR(IF('Raw Data'!A2518=0,"",'Raw Data'!A2518),"")
C3473	C3473	=IFERROR(TEXTBEFORE('Raw Data'!C2518,"-"),"")
D3473	D3473	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2518,",",2)),"m/d/yyyy"),"")
A3474	A3474	=IFERROR(TEXTAFTER('Raw Data'!C2544,"-"),"")
B3474	B3474	=IFERROR(IF('Raw Data'!A2544=0,"",'Raw Data'!A2544),"")
C3474	C3474	=IFERROR(TEXTBEFORE('Raw Data'!C2544,"-"),"")
D3474	D3474	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2544,",",2)),"m/d/yyyy"),"")
A3475	A3475	=IFERROR(TEXTAFTER('Raw Data'!C2661,"-"),"")
B3475	B3475	=IFERROR(IF('Raw Data'!A2661=0,"",'Raw Data'!A2661),"")
C3475	C3475	=IFERROR(TEXTBEFORE('Raw Data'!C2661,"-"),"")
D3475	D3475	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2661,",",2)),"m/d/yyyy"),"")
A3476	A3476	=IFERROR(TEXTAFTER('Raw Data'!C2793,"-"),"")
B3476	B3476	=IFERROR(IF('Raw Data'!A2793=0,"",'Raw Data'!A2793),"")
C3476	C3476	=IFERROR(TEXTBEFORE('Raw Data'!C2793,"-"),"")
D3476	D3476	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2793,",",2)),"m/d/yyyy"),"")
A3477	A3477	=IFERROR(TEXTAFTER('Raw Data'!C2920,"-"),"")
B3477	B3477	=IFERROR(IF('Raw Data'!A2920=0,"",'Raw Data'!A2920),"")
C3477	C3477	=IFERROR(TEXTBEFORE('Raw Data'!C2920,"-"),"")
D3477	D3477	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2920,",",2)),"m/d/yyyy"),"")
A3478	A3478	=IFERROR(TEXTAFTER('Raw Data'!C2973,"-"),"")
B3478	B3478	=IFERROR(IF('Raw Data'!A2973=0,"",'Raw Data'!A2973),"")
C3478	C3478	=IFERROR(TEXTBEFORE('Raw Data'!C2973,"-"),"")
D3478	D3478	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2973,",",2)),"m/d/yyyy"),"")
A3479	A3479	=IFERROR(TEXTAFTER('Raw Data'!C3607,"-"),"")
B3479	B3479	=IFERROR(IF('Raw Data'!A3607=0,"",'Raw Data'!A3607),"")
C3479	C3479	=IFERROR(TEXTBEFORE('Raw Data'!C3607,"-"),"")
D3479	D3479	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3607,",",2)),"m/d/yyyy"),"")
A3480	A3480	=IFERROR(TEXTAFTER('Raw Data'!C3722,"-"),"")
B3480	B3480	=IFERROR(IF('Raw Data'!A3722=0,"",'Raw Data'!A3722),"")
C3480	C3480	=IFERROR(TEXTBEFORE('Raw Data'!C3722,"-"),"")
D3480	D3480	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3722,",",2)),"m/d/yyyy"),"")
A3481	A3481	=IFERROR(TEXTAFTER('Raw Data'!C3748,"-"),"")
B3481	B3481	=IFERROR(IF('Raw Data'!A3748=0,"",'Raw Data'!A3748),"")
C3481	C3481	=IFERROR(TEXTBEFORE('Raw Data'!C3748,"-"),"")
D3481	D3481	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3748,",",2)),"m/d/yyyy"),"")
A3482	A3482	=IFERROR(TEXTAFTER('Raw Data'!C3776,"-"),"")
B3482	B3482	=IFERROR(IF('Raw Data'!A3776=0,"",'Raw Data'!A3776),"")
C3482	C3482	=IFERROR(TEXTBEFORE('Raw Data'!C3776,"-"),"")
D3482	D3482	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3776,",",2)),"m/d/yyyy"),"")
A3483	A3483	=IFERROR(TEXTAFTER('Raw Data'!C3804,"-"),"")
B3483	B3483	=IFERROR(IF('Raw Data'!A3804=0,"",'Raw Data'!A3804),"")
C3483	C3483	=IFERROR(TEXTBEFORE('Raw Data'!C3804,"-"),"")
D3483	D3483	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3804,",",2)),"m/d/yyyy"),"")
A3484	A3484	=IFERROR(TEXTAFTER('Raw Data'!C3822,"-"),"")
B3484	B3484	=IFERROR(IF('Raw Data'!A3822=0,"",'Raw Data'!A3822),"")
C3484	C3484	=IFERROR(TEXTBEFORE('Raw Data'!C3822,"-"),"")
D3484	D3484	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3822,",",2)),"m/d/yyyy"),"")
A3485	A3485	=IFERROR(TEXTAFTER('Raw Data'!C3837,"-"),"")
B3485	B3485	=IFERROR(IF('Raw Data'!A3837=0,"",'Raw Data'!A3837),"")
C3485	C3485	=IFERROR(TEXTBEFORE('Raw Data'!C3837,"-"),"")
D3485	D3485	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3837,",",2)),"m/d/yyyy"),"")
A3486	A3486	=IFERROR(TEXTAFTER('Raw Data'!C3872,"-"),"")
B3486	B3486	=IFERROR(IF('Raw Data'!A3872=0,"",'Raw Data'!A3872),"")
C3486	C3486	=IFERROR(TEXTBEFORE('Raw Data'!C3872,"-"),"")
D3486	D3486	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3872,",",2)),"m/d/yyyy"),"")
A3487	A3487	=IFERROR(TEXTAFTER('Raw Data'!C3890,"-"),"")
B3487	B3487	=IFERROR(IF('Raw Data'!A3890=0,"",'Raw Data'!A3890),"")
C3487	C3487	=IFERROR(TEXTBEFORE('Raw Data'!C3890,"-"),"")
D3487	D3487	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3890,",",2)),"m/d/yyyy"),"")
A3488	A3488	=IFERROR(TEXTAFTER('Raw Data'!C962,"-"),"")
B3488	B3488	=IFERROR(IF('Raw Data'!A962=0,"",'Raw Data'!A962),"")
C3488	C3488	=IFERROR(TEXTBEFORE('Raw Data'!C962,"-"),"")
D3488	D3488	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G962,",",2)),"m/d/yyyy"),"")
A3489	A3489	=IFERROR(TEXTAFTER('Raw Data'!C2279,"-"),"")
B3489	B3489	=IFERROR(IF('Raw Data'!A2279=0,"",'Raw Data'!A2279),"")
C3489	C3489	=IFERROR(TEXTBEFORE('Raw Data'!C2279,"-"),"")
D3489	D3489	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2279,",",2)),"m/d/yyyy"),"")
A3490	A3490	=IFERROR(TEXTAFTER('Raw Data'!C2439,"-"),"")
B3490	B3490	=IFERROR(IF('Raw Data'!A2439=0,"",'Raw Data'!A2439),"")
C3490	C3490	=IFERROR(TEXTBEFORE('Raw Data'!C2439,"-"),"")
D3490	D3490	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2439,",",2)),"m/d/yyyy"),"")
A3491	A3491	=IFERROR(TEXTAFTER('Raw Data'!C2448,"-"),"")
B3491	B3491	=IFERROR(IF('Raw Data'!A2448=0,"",'Raw Data'!A2448),"")
C3491	C3491	=IFERROR(TEXTBEFORE('Raw Data'!C2448,"-"),"")
D3491	D3491	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2448,",",2)),"m/d/yyyy"),"")
A3492	A3492	=IFERROR(TEXTAFTER('Raw Data'!C2523,"-"),"")
B3492	B3492	=IFERROR(IF('Raw Data'!A2523=0,"",'Raw Data'!A2523),"")
C3492	C3492	=IFERROR(TEXTBEFORE('Raw Data'!C2523,"-"),"")
D3492	D3492	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2523,",",2)),"m/d/yyyy"),"")
A3493	A3493	=IFERROR(TEXTAFTER('Raw Data'!C2571,"-"),"")
B3493	B3493	=IFERROR(IF('Raw Data'!A2571=0,"",'Raw Data'!A2571),"")
C3493	C3493	=IFERROR(TEXTBEFORE('Raw Data'!C2571,"-"),"")
D3493	D3493	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2571,",",2)),"m/d/yyyy"),"")
A3494	A3494	=IFERROR(TEXTAFTER('Raw Data'!C2834,"-"),"")
B3494	B3494	=IFERROR(IF('Raw Data'!A2834=0,"",'Raw Data'!A2834),"")
C3494	C3494	=IFERROR(TEXTBEFORE('Raw Data'!C2834,"-"),"")
D3494	D3494	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2834,",",2)),"m/d/yyyy"),"")
A3495	A3495	=IFERROR(TEXTAFTER('Raw Data'!C3717,"-"),"")
B3495	B3495	=IFERROR(IF('Raw Data'!A3717=0,"",'Raw Data'!A3717),"")
C3495	C3495	=IFERROR(TEXTBEFORE('Raw Data'!C3717,"-"),"")
D3495	D3495	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3717,",",2)),"m/d/yyyy"),"")
A3496	A3496	=IFERROR(TEXTAFTER('Raw Data'!C3728,"-"),"")
B3496	B3496	=IFERROR(IF('Raw Data'!A3728=0,"",'Raw Data'!A3728),"")
C3496	C3496	=IFERROR(TEXTBEFORE('Raw Data'!C3728,"-"),"")
D3496	D3496	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3728,",",2)),"m/d/yyyy"),"")
A3497	A3497	=IFERROR(TEXTAFTER('Raw Data'!C3741,"-"),"")
B3497	B3497	=IFERROR(IF('Raw Data'!A3741=0,"",'Raw Data'!A3741),"")
C3497	C3497	=IFERROR(TEXTBEFORE('Raw Data'!C3741,"-"),"")
D3497	D3497	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3741,",",2)),"m/d/yyyy"),"")
A3498	A3498	=IFERROR(TEXTAFTER('Raw Data'!C3754,"-"),"")
B3498	B3498	=IFERROR(IF('Raw Data'!A3754=0,"",'Raw Data'!A3754),"")
C3498	C3498	=IFERROR(TEXTBEFORE('Raw Data'!C3754,"-"),"")
D3498	D3498	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3754,",",2)),"m/d/yyyy"),"")
A3500	A3500	=IFERROR(TEXTAFTER('Raw Data'!C3809,"-"),"")
B3500	B3500	=IFERROR(IF('Raw Data'!A3809=0,"",'Raw Data'!A3809),"")
C3500	C3500	=IFERROR(TEXTBEFORE('Raw Data'!C3809,"-"),"")
D3500	D3500	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3809,",",2)),"m/d/yyyy"),"")
A3501	A3501	=IFERROR(TEXTAFTER('Raw Data'!C3811,"-"),"")
B3501	B3501	=IFERROR(IF('Raw Data'!A3811=0,"",'Raw Data'!A3811),"")
C3501	C3501	=IFERROR(TEXTBEFORE('Raw Data'!C3811,"-"),"")
D3501	D3501	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3811,",",2)),"m/d/yyyy"),"")
A3502:A3503	A3502	=IFERROR(TEXTAFTER('Raw Data'!C3815,"-"),"")
B3502:B3503	B3502	=IFERROR(IF('Raw Data'!A3815=0,"",'Raw Data'!A3815),"")
C3502:C3503	C3502	=IFERROR(TEXTBEFORE('Raw Data'!C3815,"-"),"")
D3502:D3503	D3502	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3815,",",2)),"m/d/yyyy"),"")
A3504	A3504	=IFERROR(TEXTAFTER('Raw Data'!C3827,"-"),"")
B3504	B3504	=IFERROR(IF('Raw Data'!A3827=0,"",'Raw Data'!A3827),"")
C3504	C3504	=IFERROR(TEXTBEFORE('Raw Data'!C3827,"-"),"")
D3504	D3504	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G3827,",",2)),"m/d/yyyy"),"")
A3505	A3505	=IFERROR(TEXTAFTER('Raw Data'!C824,"-"),"")
B3505	B3505	=IFERROR(IF('Raw Data'!A824=0,"",'Raw Data'!A824),"")
C3505	C3505	=IFERROR(TEXTBEFORE('Raw Data'!C824,"-"),"")
D3505	D3505	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G824,",",2)),"m/d/yyyy"),"")
A3506	A3506	=IFERROR(TEXTAFTER('Raw Data'!C951,"-"),"")
B3506	B3506	=IFERROR(IF('Raw Data'!A951=0,"",'Raw Data'!A951),"")
C3506	C3506	=IFERROR(TEXTBEFORE('Raw Data'!C951,"-"),"")
D3506	D3506	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G951,",",2)),"m/d/yyyy"),"")
A3507	A3507	=IFERROR(TEXTAFTER('Raw Data'!C1039,"-"),"")
B3507	B3507	=IFERROR(IF('Raw Data'!A1039=0,"",'Raw Data'!A1039),"")
C3507	C3507	=IFERROR(TEXTBEFORE('Raw Data'!C1039,"-"),"")
D3507	D3507	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G1039,",",2)),"m/d/yyyy"),"")
A3508:A3509	A3508	=IFERROR(TEXTAFTER('Raw Data'!C1047,"-"),"")
B3508:B3509	B3508	=IFERROR(IF('Raw Data'!A1047=0,"",'Raw Data'!A1047),"")
C3508:C3509	C3508	=IFERROR(TEXTBEFORE('Raw Data'!C1047,"-"),"")
D3508:D3509	D3508	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G1047,",",2)),"m/d/yyyy"),"")
A3510	A3510	=IFERROR(TEXTAFTER('Raw Data'!C1107,"-"),"")
B3510	B3510	=IFERROR(IF('Raw Data'!A1107=0,"",'Raw Data'!A1107),"")
C3510	C3510	=IFERROR(TEXTBEFORE('Raw Data'!C1107,"-"),"")
D3510	D3510	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G1107,",",2)),"m/d/yyyy"),"")
A3511	A3511	=IFERROR(TEXTAFTER('Raw Data'!C2434,"-"),"")
B3511	B3511	=IFERROR(IF('Raw Data'!A2434=0,"",'Raw Data'!A2434),"")
C3511	C3511	=IFERROR(TEXTBEFORE('Raw Data'!C2434,"-"),"")
D3511	D3511	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2434,",",2)),"m/d/yyyy"),"")
A3512	A3512	=IFERROR(TEXTAFTER('Raw Data'!C2538,"-"),"")
B3512	B3512	=IFERROR(IF('Raw Data'!A2538=0,"",'Raw Data'!A2538),"")
C3512	C3512	=IFERROR(TEXTBEFORE('Raw Data'!C2538,"-"),"")
D3512	D3512	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2538,",",2)),"m/d/yyyy"),"")
A3513	A3513	=IFERROR(TEXTAFTER('Raw Data'!C2574,"-"),"")
B3513	B3513	=IFERROR(IF('Raw Data'!A2574=0,"",'Raw Data'!A2574),"")
C3513	C3513	=IFERROR(TEXTBEFORE('Raw Data'!C2574,"-"),"")
D3513	D3513	=IFERROR(TEXT(DATEVALUE(TEXTBEFORE('Raw Data'!G2574,",",2)),"m/d/yyyy"),"")

 

[phillipc1]

I have been looking into this more and after testing, it looks like column B (Date) in the first sheet (Daily Tracker) is not matching to column D (Initial Connection) of the second sheet (Installed Units). I tested manually typing in the appropriate dates in column D (Initial Connection) from the Installed Units tab and it was working, which leads me to believe that something needs to change in column D to be able to map the two.

This is the current formula I am using now in Column F (PCs served) that I have tested. Again, this formula works if I manually enter the date in Column D (Initial Connection), but it does not work when that column is generated via a formula.

=SUM(--(LEN(UNIQUE(FILTER('Installed Units'!C:C,'Installed Units'!D:D='Daily Tracker'!B8,"")))>0))

 

[Fluff]

The "Dates" in col D are not dates but text hence you get a count of 0, try changing the formula in col D to

=IFERROR(DATEVALUE(TEXTBEFORE('Raw Data'!G3746,",",2)),"")

 

[phillipc1]

Thanks Fluff! That did it. Looks like everything is functioning as it should now.

 

[Fluff]

You're welcome & thanks for the feedback.