Bear with me here.

I have 305K records in this file.
I have them grouped by Social Security Number and last name.
I am then telling it to give me a distinct count of the number of SSNs in the group.

So I have a group of like 20K blanks, and then the rest of the report. What I want to do is count the number of groups that have a unique SSN, the number of groups that have 2 in the count, the number of groups that have 3 in the count, etc. Does that make sense?

And can I do this!?

Thank you!