ChefDonald
New Member
- Joined
- Mar 23, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
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:
I do have separate fiscal weeks by year in columns that I can utilize to separate data by week by year
small sample: