Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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: 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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I have two columns (A) and (G) that have like product codes however
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum product of many pairs of columns | Excel Worksheet Functions | |||
How do I wrap Excel columns in a printout? | Excel Discussion (Misc queries) | |||
Formulations? | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) |