View Single Post
  #2   Report Post  
 
Posts: n/a
Default 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