Array formula for unique dates for specific names

[amendoza19]

Hello,

I am trying to count the number of unique dates between 1/1/2018 and 12/31/2019 for specific Well names. For example, Well Name (29-6 64N) has 5 rows of dates in which 4 of those are unique and the other is repeated. Is there a way to count how many dates are unique for each Well Name?

Well Name is in column B with 1039 rows
Dates are in column I with 1039 rows

keep in mind that I have a sheet without repeated Well Names so now im just trying to add how many times the names are repeated by using the dates as a reference

thank you

 

[Aryatect]

Hi,

Below should work for you:

Book1
	A	B	C	D	E
1	Well	Date
2	29-6 64N	7/12/2019		29-6 64N	4
3	29-6 64N	7/12/2019
4	29-6 64N	7/12/2019
5	29-6 64N	7/12/2019
6	29-6 64N	7/12/2019
7	29-6 64N	7/12/2019
8	29-6 64N	7/13/2019
9	29-6 64N	7/14/2019
10	29-6 64N	7/15/2019
11	29-6 32N	7/16/2019
12	29-6 32N	7/14/2019
13	29-6 32N	7/15/2019
14	29-6 32N	7/15/2019
15	29-6 32N	7/15/2019
16	29-6 32N	7/15/2019
17	29-6 32N	7/15/2019
18	29-6 32N	7/15/2019
19	29-6 32N	7/15/2019
Sheet2

Cell Formulas
Range	Formula
E2	{=SUM(IF(FREQUENCY(IF($A$2:$A$19=D2,B2:B19),B2:B19),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[amendoza19]

Thank you so much!!!

 

[Aryatect]

Glad could help!

 

[amendoza19]

By any chance do you know where to add a criteria where it does the same thing but in a date range??

 

[amendoza19]

Glad could help!

I don't know how to tag people so you can see this haha

 

[Aryatect]

Hi, Sorry missed this, will this work?

Book1
	A	B	C	D	E	F
1	Well	Date
2	29-6 64N	7/12/2019		29-6 64N	7/12/2019	1
3	29-6 64N	7/12/2019
4	29-6 64N	7/12/2019
5	29-6 64N	7/12/2019
6	29-6 64N	7/12/2019
7	29-6 64N	7/12/2019
8	29-6 64N	7/13/2019
9	29-6 64N	7/14/2019
10	29-6 64N	7/15/2019
11	29-6 32N	7/16/2019
12	29-6 32N	7/14/2019
13	29-6 32N	7/15/2019
14	29-6 32N	7/15/2019
15	29-6 32N	7/15/2019
16	29-6 32N	7/12/2019
17	29-6 32N	7/20/2019
18	29-6 32N	7/15/2019
19	29-6 32N	7/15/2019
Sheet2

Cell Formulas
Range	Formula
F2	{=SUM(IF(FREQUENCY(IF(($A$2:$A$19=D2)*($B$2:$B$19=E2),$B$2:$B$19),$B$2:$B$19),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[amendoza19]

How would it be for like "<"&Date(2019,1,1) so basically everything before 2019

 

[Aryatect]

so in place of $B$2:$B$19=E2 use $B$2:$B$19 < <date(2019,1,1)< font=""></date(2019,1,1)<>Date(2019,1,1)

[/COLOR][COLOR=#333333]=SUM([/COLOR][COLOR=Blue]IF([COLOR=Red]FREQUENCY([COLOR=Green]IF([COLOR=Purple]([COLOR=Teal]$A$2:$A$19=D2[/COLOR])*([/COLOR][/COLOR][/COLOR][/COLOR][COLOR=#008080]$B$2:$B$19 < [/COLOR][COLOR=#333333]<date(2019,1,1)< font=""></date(2019,1,1)<>[/COLOR][COLOR=#333333]Date(2019,1,1)[/COLOR][COLOR=Blue][COLOR=Red][COLOR=Green][COLOR=Purple]),$B$2:$B$19[/COLOR]),$B$2:$B$19[/COLOR]),1[/COLOR])[/COLOR][COLOR=#333333])[/COLOR][COLOR=#333333]

Enter with Ctrl+Shift+Enter

 

[amendoza19]

the issues is that i have dates from 2018 in between those of 2019