# Identify Same Product Orders

##### New Member
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

Excel Workbook
ABCDEF
1Order NumberProduct(Either 1 or 0)Identifier
21000baseball1baseball
31000baseball1
41000baseball1
51001football0
71002baseball0
81003baseball0
91003baseball0
101003baseball0
111003baseball0
121004baseball0
131004football0
141005baseball1
151005baseball1
16
Sheet2
Excel 2007

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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

Excel Workbook
ABCDEF
1Order NumberProduct(Either 1 or 0)Identifier
21000baseball1baseball
31000baseball1
41000baseball1
51001football0
71002baseball0
81003baseball0
91003baseball0
101003baseball0
111003baseball0
121004baseball0
131004football0
141005baseball1
151005baseball1
16
Sheet2
Excel 2007
Try this entered in C2 and copied down:

=--(COUNTIFS(A\$2:A\$20,A2,B\$2:B\$20,B2)>1)

Thanks Valko. But what if i wanted to identify order numbers that dont have duplicates to?

Thanks Valko. But what if i wanted to identify order numbers that dont have duplicates to?
Like this...

=--(COUNTIFS(A\$2:A\$20,A2,B\$2:B\$20,B2)=1)

Replies
1
Views
388
Replies
8
Views
531
Replies
16
Views
376
Replies
5
Views
327
Replies
3
Views
726

1,203,462
Messages
6,055,562
Members
444,799
Latest member
CraigCrowhurst

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back