Remove Duplicate Values in an Index Return?

[phatmo111]

Hello I have been searching for over a week now on how to fix my issue. What i'm trying to do is use an INDEX function to return a list of "Labor Categories" based on a concactinated number. I got that part of the function down and works. But is there a way to remove duplicate values? Please see my example below.

My Formula: {=INDEX('Cost Prop'!$B$1:$C$15,SMALL(IF('Cost Prop'!$B$1:$B$15=$C$6,ROW('Cost Prop'!$B$1:$C$15)),ROW('Cost Prop'!$B2:$C2)),2)}

Example:
A B
1 110 Analyst 1
2 110 Analyst 2
3 110 Analyst 2
4 110 Analyst 4

Current Output: Is there a way to remove the 2nd Analyst 2?
Analyst 1
Analyst 2
Analyst 2
Analyst 4

Thanks for any help or advise.

[NBVC]

Try this.

In the Cost Prop sheet, I2 add formula:

Please Login or Register  to view this content.

copied down

and in J2 add formula:

Please Login or Register  to view this content.

Then in the Compare sheet, D8 enter formula:

Please Login or Register  to view this content.

This is a regular formula, no CSE confirmation required... and copied down.

[phatmo111]

That works just as i wanted it to. Thank you so much for your help. I was killing myself thinking the INDEX was the only way to go.