Hi all,
I have some survey data I am trying to analyze. Identifiers were given but not all participants provided their IDs for the post and follow up surveys. I am trying to find a way to match participants from the pre surveys to the post using demographics (i.e., gender, ethnicity, job title, etc). Does anybody have any ideas on how to do this? We have hundreds of participants so it would be difficult to do it by hand. Any advice is much appreciated!!
Thank you!
Hi - can you post a small sample size of your data?
Sure, here is an example of what the data looks like for the pre worksheet. The post looks exactly the same.
This formula will return 8
Because we are looking for Entry 8 in the original table.
So modifying it to look at the new table will give you the row number where that entry is.
=MATCH(B8&":"&J8&":"&L8&":"&M8,B:B&":"&J:J&":"&L:L&":"&M:M,0)
Then Use the Index Function to return your data.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks