Hey guys..
I need help with a formula to search down col C of "PO QTY"and then create one long list on the "list" worksheet which lists every iteration of the part number and its matching "date" and "qty" for each instance. As you will see in the example, the part number is listed once but there may me many instances of "date" and "qty" to the right. I need a long list of all the parts and corresponding dates and qtys. Like this:
23101143 9/9/13 10
23101143 9/15/13 20
23101166 9/1/13 45
I will use this list in a pivot table later. I have attached an example. Any help will be GREATLY appreciated.!! This has been a real stumper for me!!!index sample.xlsx
Bookmarks