Hi guys,
First of all, I would like to say that I've done some research before posting here. I know similar questions have already been asked, but I just couldn't get every thing to work.
So I'm doing a project on a survey for my statistics classes, for which I received a few spreadsheet to work with. I have this "individu" spreadsheet that contains 14045 entries (one for each person interviewed) and this "kish" spreadsheet that contains 5799 entries (one for each person from the "individu" sheet that responded to some extra questions in the survey). Problem is that I'm mostly interested in the answers displayed in the "kish" spreadsheet, but I want to be able to use the data that is displayed in the "individu" spreadsheet.
What I want to do is to copy complete rows from the "individu" spreadsheet to the "kish" spreadsheet that obey to two rules:
- the "IDENT" value of the row in "individu" must match the "IDENT" value of the corresponding row in "kish"
- the "NO" value of the row in "individu" must match the "NO" value of the corresponding row in "kish"
What should I do?
Thanks in advance!
OBS: tried to upload the excel file, but it exceeds 7 MB and I keep getting an error when trying to upload it in a zip file, so I uploaded screenshots from each of the spreadsheets!
Bookmarks