FALSE popped up I put the correct letters in place of the ones you had in
there and it still didn't respnded correctly. Here is an example of what the
numbers look like that i key in 239089
694185
276784 All of which are keyed in column D


"Bob Phillips" wrote:

Do want to expand on that? What did happen?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"items entered twice" wrote in
message ...
i'm sorry i tried that and it wouldn't work correctly

"Bob Phillips" wrote:

You could use conditional formatting, with a formula of say
=COUNTIF(B:B,B1)1. This will then highlight them both as you enter it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"items entered twice" <items entered
wrote
in message ...
I enter orders we receive for our business. I list them down in a
column,
is
there anyway I can tell if I have entered one more than once without
having
to go back and check every time?