is they a way to index match more than once?

[tonywatsonhelp]

Hi Everyone,

I'm try to make a list based on a name selected

I'm getting stuck so please help if you can

Column A has names in it Repeated lots of time with column be having interests,
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]nAME

[/TD]
[TD]Interests
[/TD]
[TD]Sub
[/TD]
[TD][/TD]
[TD]Chosen Name
[/TD]
[TD][/TD]
[TD]Unique List
[/TD]
[TD]G is what i'm trying to create from A and b
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]tony
[/TD]
[TD]Film
[/TD]
[TD]Horry
[/TD]
[TD][/TD]
[TD]tony
[/TD]
[TD][/TD]
[TD]Film
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]bob
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Books
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]bob
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]sue
[/TD]
[TD]books
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]tony
[/TD]
[TD]Books
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]tony
[/TD]
[TD]Books
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]bob
[/TD]
[TD]books
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]sue
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]sue
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]bob
[/TD]
[TD]books
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]tony
[/TD]
[TD]Film
[/TD]
[TD]Comedy
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD]bob
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD]sue
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]dave
[/TD]
[TD]books
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dave
[/TD]
[TD]film
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to create a list of just the unique interests in column b in column J

 

[Eric W]

Put this in G2:

=IFERROR(INDEX(B:B,SMALL(IF($A$2:$A$16=$E$2,IF(COUNTIF($G$1:$G1,$B$2:$B$16)=0,ROW($A$2:$A$16))),1)),"")

change the ranges to match your sheet, and confirm with Control+Shift+Enter, not just enter. Then drag it down the column.

I'm not sure what you want in column J? Is it a list of all the interests, regardless of the person? If so,

=IFERROR(INDEX(B:B,SMALL(IF(COUNTIF($J$1:$J1,$B$2:$B$16)=0,ROW($B$2:$B$16)),1)),"")

in J2 with CSE.

 

[tonywatsonhelp]

Hi Eric,

This is great, thank you very much
Tony

 

[Eric W]

You're welcome!