count unique entries based on 2 criteria - not able to use filter

[swqa123]

Hi...simple problem but wracking my brain!
sample data

order number	route	Date
1​	1​	01-Jul​
1​	1​	01-Jul​
3​	2​	01-Jul​
4​	1​	02-Jul​
2​	2​	02-Jul​
1​	2​	02-Jul​

I want to create a count of unique order numbers when route and date match so...
if route = 2 and date = 2nd july, unique order count = 2 etc
i cannot use unique and filter combo as using excel v2019

any help really appreciated

 

[JEC]

Close with Ctrl + shift + enter

Book1
	A	B	C	D	E	F	G
1	order number	route	Date			route	2
2	1	2	2-jul			date	2-jul
3	1	1	1-jul
4	3	2	1-jul			unique count	2
5	4	1	2-jul
6	2	2	2-jul
7	1	2	2-jul
8
Sheet1

Cell Formulas
Range	Formula
G4	G4	=SUMPRODUCT(--(FREQUENCY(IF((B2:B7=G1)*(C2:C7=G2),MATCH(A2:A7,A2:A7,0),""),ROW(A2:A7)-1)>0))

 

[swqa123]

JEC - stunning job and I thank you for taking the time to look at my problem and come up with the solution.

 

[JEC]

You're welcome, cheers!