Thanks for the replies. The more that I look into summaries, the more I realize I have a lot to learn.
I have figured out how to limit summary results to items that appear a certain number of times by count. However, I'm still not clear on how to sort a summary by count. It seems like I'd add count as an item (as opposed to a key or a measure) to do this, but this option is grayed out.
What I'm trying to do is look for duplicate names in a report of demographic data. The names are separated into first and last. I can create a calculated field combining them and impose the count constraint on that, but I wasn't clear on how to do this by adding last name as the primary key and first name as the secondary key. Does anyone know if there is a way to do this? I'd appreciate any advice anyone can give.
I think you are better off to make a single key using the LastName+FirstName (plus another with central initial(s) maybe) route and making sure that any potential data entries anomalies (remove excess spaces, punctuation, etc.) are considered. Add in a check for possible anomalies using whatever 'rules' you suspect are necessary. The usable rules may only become clear as you work with the data.
By doing it this way and keeping it simple if you get unexpected results - and with names (and address) databases it would be the normal situation in my experience - you have a way to see the sources quite quickly and clearly.