Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding data
I hope someone can help me on this:
I have an inventory database where thousands of parts have different bin locations. What I need is a formula(s) that can tell me all bin locations where a part is located but horizontally. For example, I have a master data that looks something like this: Part # Bin Locations 1111 A1 2222 B5 3333 G7 1111 H9 7777 C2 8888 D1 1111 E3 4444 F8 5555 A3 6666 H2 2222 B9 3333 E2 Then, in sheet 2 my final result should be something like this: Part # Location 1 Location 2 Location 3 Location 4 etc 1111 A1 H9 E3 2222 B5 B9 3333 G7 E2 4444 F8 5555 A3 6666 H2 7777 C2 8888 D1 Data on Part # column should be entered manually and the Bin Location info automatically after I typed the part # |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Data | Excel Worksheet Functions | |||
finding data in same sheet | Excel Discussion (Misc queries) | |||
Finding data | Excel Discussion (Misc queries) | |||
Finding max row containing data... | Excel Discussion (Misc queries) | |||
finding data | Excel Worksheet Functions |