Forum Discussion
How to select cases
I suspect you are looking for one of several functions that allow you to find the P-number in the bigger list and take information from there to the smaller list. Simplest would be VLOOKUP. Otherwise a combination of INDEX and MATCH or perhaps XLOOKUP (if available on your version of Excel).
It all depends on how your data tables are structured.
Riny_van_Eekelen Thank you for your answer! I could use the VLOOKUP command, but the bigger data has several (tens) columns that I need. Do you know any way to for example delete all the cases that are not included in the smaller data?
RikuTauschi Perhaps like in the attached file?
Riny_van_Eekelen Yes, but the columns are different in each data. I edited your document and it's in attachments now. So I need the small data participants from the big data with big data's information.
The amount of rows in my real data is 800 and the amount of columns is about 40.
Like so? (please see the attached file)