Unique List Generator Based on Prefix

[BMcHale]

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

A	B	C	D
1	List		Prefix	List
2	N12111		N1	N12111
3	M14999			N12987
4	N12987			N12555
5	A33001
6	N33444
7	N12555
8	A33888
9
10

<tbody>
</tbody>

Sheet14​

Array Formulas Cell Formula D2 {=IF(D1="","",IFERROR(INDEX($A$2:$A$100,SMALL(IF(LEFT($A$2:$A$100,LEN($C$2))=$C$2,ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($D$2:$D2))),""))} <tbody> </tbody>

<tbody>
</tbody>

</body>Hi All,

I'm using an array function to list values with a specified prefix, However the function I'm using will still obviously list duplicated values, Is there any way in which my formula can be edited, or indeed a new formula created that will give a list of unique values with a specified prefix.

Below is an example of what I'd be after and my currently used formula.

A	B	C	D
1	List		Prefix	List
2	N12555		N12	N12555
3	M14999			N12987
4	N12987			N12111
5	A33001
6	N12555
7	A33888
8	N12111
9	M14648
10	N12987

<tbody>
</tbody>

Sheet14​

Array Formulas Cell Formula D2 {=IF(D1="","",IFERROR(INDEX($A$2:$A$100,SMALL(IF(LEFT($A$2:$A$100,LEN($C$2))=$C$2,ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($D$2:$D2))),""))} <tbody> </tbody>

<tbody>
</tbody>