Can someone please answer this question? I need to know the answer as well.
OK Eric, if you post a data sample of this problem I'll be happy to take a look. The reason these Q's go unanswered is probably listed here. So if you can provide a bit more info about your particular question, I'm sure we can get it worked out.
Shawn, I am having a difficult time logging in and I can’t post my question. Would you like me to send my question and workbook directly?
I have a list of students (limited for size sake) that have taken a course at 'Wasatch Campus' or 'Other Campus' or both.
I would like to count the number of students who
#1 took a course at Wasatch
#2 took a course at Other
#3 took a course EXCLUSIVELY at Wasatch
#4 took a course EXCLUSIVELY at Other
(#5 there will be cases when a student is neither, but that data isn't in this example)
In the file, the 'course reference number' identifies a specific course.
I coded each course 1 if Wasatch, 1 if Other, each in their own column, and
I coded each course either 'Wasatch' or 'Other' in another column. Just to cover any coding I need to use.
Thanks for the help. I am such a jam.
Wasatch Test.twbx.zip 13.0 KB