Im trying to solve for Column D within.
Column A, shows order numbers. Column B, shows products within order. Column C, shows order amounts.
I would like the formula in Column C to look at the following:
Identfy where products are the same for multi orders (If column a is a duplicate order number and column b shows the same product for each order) MARK I, if not MARK 0 - identifier calls out what products to look for - F2
Please let me know. Thanks
Excel 2007
Column A, shows order numbers. Column B, shows products within order. Column C, shows order amounts.
I would like the formula in Column C to look at the following:
Identfy where products are the same for multi orders (If column a is a duplicate order number and column b shows the same product for each order) MARK I, if not MARK 0 - identifier calls out what products to look for - F2
Please let me know. Thanks
Excel Workbook | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Order Number | Product | (Either 1 or 0) | Identifier | ||||
2 | 1000 | baseball | 1 | baseball | ||||
3 | 1000 | baseball | 1 | |||||
4 | 1000 | baseball | 1 | |||||
5 | 1001 | football | 0 | |||||
6 | 1002 | basketball | 0 | |||||
7 | 1002 | baseball | 0 | |||||
8 | 1003 | baseball | 0 | |||||
9 | 1003 | baseball | 0 | |||||
10 | 1003 | baseball | 0 | |||||
11 | 1003 | baseball | 0 | |||||
12 | 1004 | baseball | 0 | |||||
13 | 1004 | football | 0 | |||||
14 | 1005 | baseball | 1 | |||||
15 | 1005 | baseball | 1 | |||||
16 | ||||||||
Sheet2 |