How do I prevent entering duplicate numbers in an excel worksheet
 

I have a lot of bill laden numbers I need to keep track of in an excel
worksheet for accounts payable and I want to prevent entering duplicate
numbers. Is there a way I can have excel tell me when I have keyed a
duplicate number?

Thanks for any help.

How do I prevent entering duplicate numbers in an excel worksheet
 

You can use validation to do this... Select Data - Validation - Custom and
insert the following formula (Select all of column A with Cell A1 as the
active cell)

=COUNTIF(A:A, A1)=1
--
HTH...

Jim Thomlinson


"Bran5956" wrote:

I have a lot of bill laden numbers I need to keep track of in an excel
worksheet for accounts payable and I want to prevent entering duplicate
numbers. Is there a way I can have excel tell me when I have keyed a
duplicate number?

Thanks for any help.