football card spreadsheet

From cell A2 through A660, I'm trying to catalog some football cards. my problem: to prevent myself from typing duplicate names, can I do a formula so that say Former Detroit lions player Jerry Ball, doesn't get duplicate names under player name? So is there a formula so as to prevent me...