What I'll do is the following:
Put the names in Column A and sort them.
Column B put the following Formula
=IF(A2=A1,B1+1,1)
Then go to DataFilterAutofilter
When you have the filters, Select Custom and select "is less than"
and in the rigth put 10 OK
Select all the range and then delete it.
Release the Autofilter.
Select All data Again and sort it again to have all the data together
and eliminate the deleted rows.
Saludos
NlCO
--
NlCO
------------------------------------------------------------------------
NlCO's Profile:
http://www.excelforum.com/member.php...o&userid=26123
View this thread:
http://www.excelforum.com/showthread...hreadid=402066