Creating a new list from existing list based on condition

[RLPercy]

Hi All,

Looking for some help with creating a list. In one sheet I have a list on names of people belonging to a group (column A) and then a simple y/n entry in column B as to whether they are active members or not.

I have 250 names in column A, but only 135 in column B that are active members

What I am trying to do is to automatically create a list in a new sheet of those members that are active so that I end up with list of 135 names in the new sheet (one after the other) without any repetition. I am trying to achieve this using only formulas and without any VBA code (as I know nothing about VBA)

The closest I have got is:

=INDEX(A1:A250,MATCH("y",B1:B250,0))


and then copying this down. The problem is that I end up with multiple entries for the same name when the formula does not find a "y".

(I realise the above doesn't reference a different sheet - I have taken that out for clarity. )

I am sure that I am probably just missing something straight forward but it is driving me crazy.

Thanks for any suggestions - would really appreciate it.