extract multiple rows of data if they have one of the values in a list

my data set contains 16598 individuals, one per row. each of these individuals are members of a gym of which there are 1241 gyms, each gym gets an ID label which is a number . i want to extract all the individuals belonging to some of the gyms only. i have a list of the gym ID labels (eg 1011, 1043 etc), in total there are 1214 gyms and i want to pull all the data on the individual members of 1019 of those gyms . how do i filter the 16598 by a list of 1019 identifiers? any help appreciated
thank in advance

A mixture of FILTER and COUNTIF.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Try:

Formula:

Please Login or Register  to view this content.

Put the formula in cell G2. List the gyms you are interested in in cells M2:M1020.

Your data lists gym, location, age, gender and marital status.

Not sure what you are looking for if it's not what has been offered.

Please upload a sample file with expected results based on the test data provided.

Is this resolved now. If it is not, please come back with more information and a sample file that is more reflective of the live file (but not necessarily the live file).

Please explain what it is you need clarification on.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.