Function to generate list of all different values/text that are appearing in the column one time or more times

[Gabrielle_erre]

Hi, I'm Gabriel and I am new to this website and I hope to find some help for the next table:
I would like to list all the codes names list from the column A (even if they appear one time or more) in column D and show in column E the description (from column B) for each of the List of codes.

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]CODE[/TD]
[TD="align: center"]DESCRIPTION[/TD]
[TD="align: center"][/TD]
[TD="align: center"]List all CODES[/TD]
[TD="align: center"]Show description[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]11-a[/TD]
[TD]you[/TD]
[TD][/TD]
[TD]11-a
[/TD]
[TD]you
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]12-a[/TD]
[TD]me[/TD]
[TD][/TD]
[TD]12-a[/TD]
[TD]me[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10-a[/TD]
[TD]us[/TD]
[TD][/TD]
[TD]10-a[/TD]
[TD]us[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]11-a[/TD]
[TD]you[/TD]
[TD][/TD]
[TD]13-a[/TD]
[TD]we[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]12-a[/TD]
[TD]me[/TD]
[TD][/TD]
[TD]#NV[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]10-a[/TD]
[TD]us[/TD]
[TD][/TD]
[TD]#NV[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]13-a[/TD]
[TD]we[/TD]
[TD][/TD]
[TD]#NV[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]11-a[/TD]
[TD]you[/TD]
[TD][/TD]
[TD]#NV[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

To list the codes in cell D1 I used
{=index($A2:$A$10, MATCH(0,COUNTIF($D$1:D1,$A$2:$A$10),0))}

But I would like to have only the values/text of codes and no error on the list, because I will refer the cells to other sheets and apply more functions.

- I did not find a function to show me the description from col B for each code listed.

Can you help with suggestions? Thanks in advance!

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E
1	CODE	DESCRIPTION		List all CODES	Show description
2	11-a	you		11-a	you
3	12-a	me		12-a	me
4	10-a	us		10-a	us
5	11-a	you		13-a	we
6	12-a	me
7	10-a	us
8	13-a	we
9	11-a	you
Input

Cell Formulas
Range	Formula
D2	=IFERROR(INDEX($A$2:$A$9, MATCH(0,INDEX(COUNTIF($D$1:D1,$A$2:$A$9),0),0)),"")
E2	=INDEX($B$2:$B$9,MATCH(D2,$A$2:$A$9,0))

 

[Gabrielle_erre]

Awesome...

It works! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback

 

[Gabrielle_erre]

I can apply the same function IFERROR also for the E2 to not have the #NV ?

If I use E2=IFERROR(INDEX($B$4:$B$10,MATCH(F4,$A$4:$A$10,0)),0) it shows 0 instead of #NV . Can you help me to correct it?

 

[Fluff]

Change the final 0 to ""

 

[Gabrielle_erre]

Super!
Thank's

 

[Fluff]

You're welcome