Forum Discussion
How to select cases
Hello,
I have a following problem:
In data participants are coded like this: P0001, P0002 etc. I have two different datas and in the bigger data there are participants P0001, P0002, P0003, P0004, P0005 and so on. And in my smaller data I have participants P0001, P0004, P0005, P0022, P0043 and so on.
I need to select the small data cases from the bigger data. What would you recommend to use to select those cases? Please ask me more info if I couldn't describe my problem clearly enough! 🙂
Thank you.
6 Replies
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?
