Responsive list / pivot - No VBA

[drcso]

Hi Guys,

Forgive me the thread title, but I had no idea how to call it.

I'm having a table, where I have to choose Yes/No. If I choose Yes, I want this choice to be displayed in another table. It can be partially done with a pivot, but I need to press refresh each time I make any changes in my choices and I do not want that - I want it to be reacting immediately to my choices.

Please take a look how it should like:

Since this file will be shared with some people I want it to be macro free but I cannot figure out which formulas to use to achieve this 'effect' (I was thinking about indexes, but gave up).

 

[James006]

Hello,

In cell A2, you can test following array formula

=IFERROR(INDEX($C$2:$C$6,SMALL(IF($D$2:$D$6="Yes",ROW($D$2:$D$6)-1),ROW()-1)),"")

Hope this will help

 

[drcso]

Hello,

In cell A2, you can test following array formula

=IFERROR(INDEX($C$2:$C$6,SMALL(IF($D$2:$D$6="Yes",ROW($D$2:$D$6)-1),ROW()-1)),"")

Hope this will help

Thank you! Works like a charm!

 

[James006]

You are welcome ...