Counting Unique Data Sets

[ChefDonald]

I have four years of Purchase Order data with each year containing 4,000-5,000 lines. I need to count the unique number of Purchase orders EACH Week of Each year. Some purchase orders are listed once (ordering one item) but others are ordering more than one item thus listed in the flat file multiple times in each & every week per year. I need to count the actual number of different Purchase Orders per week per year for last four years.
I do have separate fiscal weeks by year in columns that I can utilize to separate data by week by year
small sample:

 

[AhoyNC]

Maybe something like this:

Book1
	A	B	C	D	E	F	G	H	I
1	Order	FW	OD	Cust#	PO		Week	Year	Count
2		1	1/2/2019		33961		1	2019	5
3		1	1/2/2019		33961		2	2019	2
4		1	1/2/2019		110084402		1	2020	2
5		1	1/2/2019		110084403
6		1	1/2/2019		110084404
7		1	1/2/2019		110084405
8		2	1/7/2019		123
9		2	1/7/2019		145
10		2	1/7/2019		123
11		1	1/2/2020		456
12		1	1/2/2020		456
13		1	1/2/2020		58
Sheet1

Cell Formulas
Range	Formula
I2:I4	I2	=ROWS(UNIQUE(FILTER($E$2:$E$13,($B$2:$B$13=G2)*(YEAR($C$2:$C$13)=H2))))

 

[sandy666]

another way with Power Query

Order	Fiscal Wk	Order Date	Oust No	Oust Name		Fiscal Wk	Year	Count
914151	1	02/01/2019	2817	TOP TAYLOR IMPORTACAO		1	2019	5
914151	1	02/01/2019	2817	TOP TAYLOR IMPORTACAO		2	2019	1
914301	1	02/01/2019	68022	Chinese EXPRESS INC
914302	1	02/01/2019	68022	Chinese EXPRESS INC
914303	1	02/01/2019	68022	Chinese EXPRESS INC
914304	1	02/01/2019	68022	Chinese EXPRESS INC
914305	2	08/01/2019	64801	Kitchen SUPPLY CHAIN SOL.

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Year = Table.AddColumn(Table.Distinct(Source), "Year", each Date.Year([Order Date]), Int64.Type),
    Group = Table.Group(Year, {"Fiscal Wk", "Year"}, {{"Count", each Table.RowCount(_), type number}})
in
    Group

 

[ChefDonald]

Maybe something like this:

Book1
	A	B	C	D	E	F	G	H	I
1	Order	FW	OD	Cust#	PO		Week	Year	Count
2		1	1/2/2019		33961		1	2019	5
3		1	1/2/2019		33961		2	2019	2
4		1	1/2/2019		110084402		1	2020	2
5		1	1/2/2019		110084403
6		1	1/2/2019		110084404
7		1	1/2/2019		110084405
8		2	1/7/2019		123
9		2	1/7/2019		145
10		2	1/7/2019		123
11		1	1/2/2020		456
12		1	1/2/2020		456
13		1	1/2/2020		58
Sheet1

Cell Formulas
Range	Formula
I2:I4	I2	=ROWS(UNIQUE(FILTER($E$2:$E$13,($B$2:$B$13=G2)*(YEAR($C$2:$C$13)=H2))))

Thank you AHOY...Will give it a shot