Counting unique values in a range/table.

[john62290]

I am looking for a formula that counts the unique number of accounts in column B that are also marked as Yes in Column C whose order dates are greater than or equal to 4/1/2024 and less than or equal to 4/7/2024. The formula would result in an answer of 4. thanks!

4/1/2024	Jones account	Yes
​ 4/1/2024	Jones Account	Yes
4/2/2024	Matthew	Yes
4/2/2024	ABC	No
4/2/2024	Bruce	Yes
4/3/2024	Jones Account	No
4/5/2024	ECL	No
4/4/2024	JHM	Yes
4/6/2024	JHM	No
4/7/2024	Jones Account	No
4/9/2024	Blair	Yes

 

[Cubist]

Try:

Book2
	A	B	C	D	E	F
1
2	4/1/2024	Jones account	Yes		4/1/2024	4/7/2024
3	4/1/2024	Jones Account	Yes		4
4	4/2/2024	Matthew	Yes
5	4/2/2024	ABC	No
6	4/2/2024	Bruce	Yes
7	4/3/2024	Jones Account	No
8	4/5/2024	ECL	No
9	4/4/2024	JHM	Yes
10	4/6/2024	JHM	No
11	4/7/2024	Jones Account	No
12	4/9/2024	Blair	Yes
Sheet4

Cell Formulas
Range	Formula
E3	E3	=ROWS(UNIQUE(FILTER(A2:B12,(C2:C12="Yes")*(A2:A12>=E2)*(A2:A12<=F2))))