Hello all:
I am putting a list together in excel and I have items in columns A to D.
If I enter an item in column a and I press enter, is there a way that excel could search column A to see if the number has been previously entered, if it's been previously entered, can I get a prompt saying "number already exists" or something like that?
Thanks so much for your help.