can any one tell me how to prevent the data entry more than once in any excel cell. say that i want to fill in the name of persons in column A but want no duplication of any name!

any guidance 'll be appreciated!