preventing duplicates
 

Is there a way to prevent the entering of a duplicate
number in a column. For example, if you are entering
Invoice numbers in Column A, is there a way to prevent
the entering of duplicate Invoice numbers? If so, explain
it.

Thanks.

Check out this web page of Chip Pearson:

http://www.cpearson.com/excel/NoDupEntry.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Bonnie" wrote in message
...
Is there a way to prevent the entering of a duplicate
number in a column. For example, if you are entering
Invoice numbers in Column A, is there a way to prevent
the entering of duplicate Invoice numbers? If so, explain
it.

Thanks.

Thank you so much for your answer. That is what we needed.

Bonnie
-----Original Message-----
Check out this web page of Chip Pearson:

http://www.cpearson.com/excel/NoDupEntry.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================

"Bonnie" wrote in
message
...
Is there a way to prevent the entering of a duplicate
number in a column. For example, if you are entering
Invoice numbers in Column A, is there a way to prevent
the entering of duplicate Invoice numbers? If so, explain
it.

Thanks.

.