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]

That should not be a problem refer to below:

Book1
	A	B	C	D	E
1	Well	Date
2	29-6 64N	7/12/2019		29-6 64N	2
3	29-6 64N	1/1/2018
4	29-6 64N	7/13/2019
5	29-6 64N	7/12/2019
6	29-6 64N	6/1/2018
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
E2	{=SUM(IF(FREQUENCY(IF(($A$2:$A$19=D2)*($B$2:$B$192019,1,1)),$B$2:$B$19),$B$2:$B$19),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[amendoza19]

I must be doing something wrong because now it wont accept the formula<date(2019,1,1),'master '!j:j),1))

Im so sorry for all this trouble I really appreciate it </date(2019,1,1),'master>

 

[amendoza19]

I must be doing something wrong because now it wont accept the formula<date(2019,1,1),'master '!j:j),1))

Im so sorry for all this trouble I really appreciate it </date(2019,1,1),'master>

=SUM(IF(FREQUENCY(IF(('Master expense sheet '!C:C=Summary!D2)*('Master expense sheet '!J:J<DATE(2019,1,1),'Master expense sheet '!J:J),'Master expense sheet '!J:J),1))

 

[Aryatect]

Did you try recreating first the example above? see if that is working for you. If that works then we can work on applying it to your sheet.

Will get this through, no worries

 

[amendoza19]

it worked!!!!! Seriously thank you so much, this is my first time using excel so im still learning a lot

 

[Aryatect]

Great, thanks for the feedback