I am working in MS Excel 2007 with data regarding a series of forum posts. Each post is represented by a row of data that includes a unique ID for each post, the unique ID of the user that posted it, the unique ID of the discussion as well as several columns of descriptive variables. One of these descriptive variables is whether or not the post supports the discussion (is a pro or a con). There are several thousand users and several thousand posts.
1. I want to find the instances where users have made more than one post in the same discussion. (Probably a few dozen instances)
2. I want the instances in which users have posted both a "pro" and a "con". (Probably a handful)
Question number one is the important one. The second will probably be easy once I've figured out #1 since the instances are few.
Alternatively, how could I accomplish this with Access (which I am much less familiar with)?