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.

Values	Looking For	If Found (No Repeats)
A	B	C
5	6	6
4	10	7
5	7	10
7
5
2
10
10
1
1
3
7
1
8
2
8
10
1
7
7
10
8
6
2
9

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

 

[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.