excel table query data duplication

excel table query data duplication, and facilitate the operation to remove, how to do

the assumption that the data in the A column, B1 enter the formula
= if (Countif (A:A, A1)> 1, “repeated “,””)
B1 can be deleted to copy the formula down in the high-level screening, screening in the inquiry excel in the table repeat the query data
A1 like to test out a8, the right to insert a blank, insert function = countif ($ a $ 1:$ a $ 8, a1)> 1, and then drag down to copy,
if the return value is true , Said on repeat, the return value is false, there will be no repeat
detailed look at the operation to go here
/ showart.asp? Art_id = 45