Thank you so much! Unfortunately the steps you described didn't give me the results I was after, but did put me on the right track. I instead ended up using the "count values within cases" option under the transform tab, and then it worked perfectly!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
