I have an example of data below. I want to be able to get a count of the Unique Member ID's that have more than 1 different confirmation number tied to it. So in the simple example below that number would be 1. Member 55555 has 3 entries, two with the same confirmation number and 1 with a different confirmation. I want to be able to create a flag in the data to flag every time a unique member ID has multiple confirmation numbers tied to it and then be able to count how many of those unique member ID's there are in the data set. Can i do a Case When statement? Nothing I have tried has worked yet. Thanks in advance.
Please sign in to leave a comment.