Delete rows listed less than 8 times???
sort you table by name.
go to Data- subtotals
At each change in name use function count on field Phone number
this will give you a count for every name
OR
create a pivot table and the use the vlookup function
I am in a rush so my apologies if this is too cryptic
|