BrettOlbrys1
Board Regular
- Joined
- May 1, 2018
- Messages
- 138
- Office Version
- 365
- Platform
- Windows
Table of Data
- Every employee (column A) has three associated employee codes (columns F - H). NOTE: 1,000+ employees
- I have a unique list of employee codes that keyed an order. NOTE: 500,000+ orders
I want a formula that COUNTS the number of UNIQUE ORDERS based on the following criteria:
- between 4/1/24 and 6/30/24
- TYPE = Validated
- matches any of their three employee codes from columns F, G, or H
The output would be the list of employee names and the # of unique orders.
Thanks
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | Column I | |
EMPLOYEE | CUSTOMER NAME | DATE | QTY | TYPE | EMPLOYEE CODE 1 | EMPLOYEE CODE 2 | EMPLOYEE CODE 3 | ||
Angie | Joe's Crab Shack | 4/1/24 | 2 | Validated | e12345 | e37892 | e43876 | ||
Grace | Tea With Tracy | 4/13/24 | 5 | Validated | e63524 | e98735 | e65326 | ||
Brett | Bob the Builder | 4/19/24 | 6 | Not Validated | e93764 | e36873 | e67590 | ||
James | Tim's Outhouse | 4/22/24 | 3 | Validated | e18943 | e15235 | e28464 | ||
James | Tim's Outhouse | 4/22/24 | 7 | Not Validated | e18943 | e15235 | e28464 | ||
Brett | Bob the Builder | 5/18/24 | 8 | Validated | e93764 | e36873 | e67590 | ||
Angie | Joe's Crab Shack | 6/3/24 | 1 | Not Validated | e12345 | e37892 | e43876 | ||
James | Tim's Outhouse | 6/30/24 | 9 | Validated | e18943 | e15235 | e28464 |
- Every employee (column A) has three associated employee codes (columns F - H). NOTE: 1,000+ employees
- I have a unique list of employee codes that keyed an order. NOTE: 500,000+ orders
I want a formula that COUNTS the number of UNIQUE ORDERS based on the following criteria:
- between 4/1/24 and 6/30/24
- TYPE = Validated
- matches any of their three employee codes from columns F, G, or H
The output would be the list of employee names and the # of unique orders.
Thanks