riddle in excel

Good evening to all

I will need your help on a problem I have.
so I have 2 tables the 1st with 3 columns and the 2nd with 2 columns
Table 1:
column 1: names
column 2: a feature
column 3: the choice to put "yes" or "no"
Table 2
column 1: ??????
column 2: a fixed feature

what I want to do is this:
when I go for example and I choose yes in the 3rd column of the first name of table 1 to appear in the first line of column 1 of table 2.
if on the next line in table 1 I choose not the second row of table 2 in column 1 to be left blank.
essentially in the 1 column of table 2 I want to display all the names I've put with yes in table 1, one below the other.

I hope that I described it is understandable. please help !!!!

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

I hope this example to be clear!!!

How about
In I3 copied down

Formula:

Please Login or Register  to view this content.

and in J3 copied down

Formula:

Please Login or Register  to view this content.

The first function works perfect.
the second function doesn't bring me the corect result but only "0"

It works for me

It works !!!!!!!!!!!!!!!
Thaaaaaanks!!!!!!!

You're welcome & thanks for the feedback