As long as it shows the results horizontally, I don't see the problem

"Don Guillett" wrote:

I would use a macro that makes a unique list and copies it to the other
sheet and then goes down that list using FINDNEXT to add each
find.offset(,1) to the list.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Byron720" wrote in message
...
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 #