ExcelBanter - View Single Post - I have two columns (A) and (G) that have like product codes however

Dave Peterson

You have an active thread elsewhere.

wrote:

I have two columns (A) and (G) that have like product codes however
they are not in any particular order. In columns (H) and ( i ) are bin
numbers that are associated with the product codes in column (G) I
would like to put these bin numbers in columns (E) and (F)
Example of what my worksheet looks like:

Prod Code Item Name Location Qty Prod Code Bin 1 Bin 2
BD0036 Oxygen 10 2 BD0100 25
42
BD0100 Vent 15 16 BD0036 17
64

What I would like for it to look like:

Product Code Item Name Location ReorderQty Bin 1 Bin 2
BD0036 Oxygen 10 2 17
64
BD0100 Vent 15 16
25 42

Note: Column (A) might have 5,000
product codes with the same product code appearing multiple times
depending on what locations carry that product and column (G) will have

20,000 unique product codes only appearing once.

--

Dave Peterson