Extract data from a list using criteria

[HughT]

Has me stumped.

Column A: Fault codes (3 digit, multiple instances in random order)
Column B: Unique serial number of part that has the fault in Column A.

Data is continuously being added to the table.

I want to use a formula to extract the serial numbers in column B into columns unique to the criteria in column A, but without gaps so that the serial numbers are in a continuous block. So for example:

A B
Fault code Serial no
123 1245
456 3071
789 7813
123 4387
789 1384
789 1179
etc

Solution
Fault code 123
1245
4387

Fault Code 789
7813
1384
1179
etc

If possible without using VBA as I have to hand this over to someone who doesn't do code.

Many thanks

HT

 

[HughT]

Thanks, I think I have discovered the problem.

Trying to make things simpler for users (or being too clever by half!) I had used a formula to make Tab Name = Cell Name (which would be the fault number), and then using that as the look up reference for this formula. The idea being that all a user had to do was copy an existing worksheet, put the fault number on the worksheet tab and the system would do the rest.

Computer said no.

Many thanks for your patience!

HT

 

[Fluff]

Glad you sorted it & thanks for the feedback