Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have two columns (A) and (G) that have like product codes however
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: Prod Code Item Name Location Qty Bin 1 Bin 2 BD0036 Oxygen 10 2 17 64 BD0100 Vent 15 16 25 42 I have 20,000 rows and would appreciate any kind of help i can get |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Querying multiple Product Codes in one field using SUMPRODUCT() | New Users to Excel | |||
I have two columns (A) and (G) that have like product codes however | Excel Worksheet Functions | |||
Sum Product if? Three columns | Excel Worksheet Functions | |||
How can i have all alike product codes in column A be matched with like cities in column B and then add the totals that are in column C | Excel Programming | |||
Sum product of many pairs of columns | Excel Worksheet Functions |