hey, I have a list of about 8500 people. some of them are duplicates for
sure.. many of them are.

what I want to do is re order the list so that the person with the most
duplicates is the first in the list (along with ALL of his duplicates) and
descend from there. know what I mean?

for example if the list was 100 people, and 30 are John, 20 are Jim and 50
are Mary it would re order the list so that

the first 50 records are mary,mary,mary all the way down,
the next 30 are john all the way down,
the last 20 are Jim

the total count remains the same. and I get to see who has the most
duplicates. I'm in a situation where I have 10 excel spreadsheets, and if
there is 10 of one guy, then he can go into each excel spreadsheet. if
someone only has 5, then he only goes into 5 different excel spreadsheets.

any help in VBA or formula will work. I have a BS in CS and I'm a software
developer.