Identify Same Product Orders

Squad

New Member
Joined
Jul 18, 2011
Messages
32
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 Workbook
ABCDEF
1Order NumberProduct(Either 1 or 0)Identifier
21000baseball1baseball
31000baseball1
41000baseball1
51001football0
61002basketball0
71002baseball0
81003baseball0
91003baseball0
101003baseball0
111003baseball0
121004baseball0
131004football0
141005baseball1
151005baseball1
16
Sheet2
Excel 2007
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
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 Workbook
ABCDEF
1Order NumberProduct(Either 1 or 0)Identifier
21000baseball1baseball
31000baseball1
41000baseball1
51001football0
61002basketball0
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)
 
Upvote 0
Thanks Valko. But what if i wanted to identify order numbers that dont have duplicates to?
 
Upvote 0

Forum statistics

Threads
1,223,192
Messages
6,170,644
Members
452,344
Latest member
LarryRSch

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top