Index Match no Duplicate list

[help2017]

Hi,

I'm sorry if this has been answered before, I'm new to excel. My problem:

Im trying to build a list of specific values to find in column A (The Actual Sheet has text not number in columnA), Thus Column B has the Criteria to find in Text form, and Column C is the output with no repeats. No repeats means if 6 is already found, move on to the next search criteria of 10 and so on. I Apologize if I'm not making this clear enough in advance.

This is what i have so far:{=IFERROR(INDEX($A$29:$A$104,MATCH('Skill List'!Y123,Sheet!$A$29:$A$104,0),),"")}
The problem with this formula is only looks for 1 criteria, not multiple.

[TABLE="width: 313"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]Values[/TD]
[TD]Looking For[/TD]
[TD]If Found (No Repeats)[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]7[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

In C2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$2:$A$26,SMALL(IF(FREQUENCY(IF(1-($A$2:$A$26=""),IF(ISNUMBER(MATCH($A$2:$A$26,$B$2:$B$4,0)),
    MATCH($A$2:$A$26,$A$2:$A$26,0))),ROW($A$2:$A$26)-ROW($A$2)+1),ROW($A$2:$A$26)-ROW($A$2)+1),ROWS($C$2:C2))),"")

 

[help2017]

In C2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$2:$A$26,SMALL(IF(FREQUENCY(IF(1-($A$2:$A$26=""),IF(ISNUMBER(MATCH($A$2:$A$26,$B$2:$B$4,0)),
    MATCH($A$2:$A$26,$A$2:$A$26,0))),ROW($A$2:$A$26)-ROW($A$2)+1),ROW($A$2:$A$26)-ROW($A$2)+1),ROWS($C$2:C2))),"")

That works perfectly! your are a genius. Thanks again.

 

[Aladin Akyurek]

That works perfectly! your are a genius. Thanks again.

You are welcome.