software

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?You could use conditional formatting, with a formula of say
=COUNTIF(B:B,B1)gt;1. This will then highlight them both as you enter it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

If you apply a conditional format to your column your can make duplicate
entires stand out, so as soon as the second value is entered they will
both change colour

If your data is in column A try the following in cell a2

=COUNTIF(A:A,a2)gt;1 entered under formula is in conditional formating
and select a colour to highlight it

This can then be copied and pasted as formats to the other cells

If it does not work, check that excel has not enclosed the formula in
quotes, if it has delete them!

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=538446thank you that is a great idea i will try that

quot;items entered twicequot; wrote:

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

thank you that has helped

quot;Davquot; wrote:

gt;
gt; If you apply a conditional format to your column your can make duplicate
gt; entires stand out, so as soon as the second value is entered they will
gt; both change colour
gt;
gt; If your data is in column A try the following in cell a2
gt;
gt; =COUNTIF(A:A,a2)gt;1 entered under formula is in conditional formating
gt; and select a colour to highlight it
gt;
gt; This can then be copied and pasted as formats to the other cells
gt;
gt; If it does not work, check that excel has not enclosed the formula in
gt; quotes, if it has delete them!
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=538446
gt;
gt;

i'm sorry i tried that and it wouldn't work correctly

quot;Bob Phillipsquot; wrote:

gt; You could use conditional formatting, with a formula of say
gt; =COUNTIF(B:B,B1)gt;1. This will then highlight them both as you enter it.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;items entered twicequot; lt;items entered gt; wrote
gt; in message ...
gt; gt; I enter orders we receive for our business. I list them down in a column,
gt; is
gt; gt; there anyway I can tell if I have entered one more than once without
gt; having
gt; gt; to go back and check every time?
gt; gt;
gt;
gt;
gt;

i'm sorry i tried and it wouldn't work correctly

quot;Davquot; wrote:

gt;
gt; If you apply a conditional format to your column your can make duplicate
gt; entires stand out, so as soon as the second value is entered they will
gt; both change colour
gt;
gt; If your data is in column A try the following in cell a2
gt;
gt; =COUNTIF(A:A,a2)gt;1 entered under formula is in conditional formating
gt; and select a colour to highlight it
gt;
gt; This can then be copied and pasted as formats to the other cells
gt;
gt; If it does not work, check that excel has not enclosed the formula in
gt; quotes, if it has delete them!
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=538446
gt;
gt;

Do want to expand on that? What did happen?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;items entered twicequot; gt; wrote in
message ...
gt; i'm sorry i tried that and it wouldn't work correctly
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; You could use conditional formatting, with a formula of say
gt; gt; =COUNTIF(B:B,B1)gt;1. This will then highlight them both as you enter it.
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;items entered twicequot; lt;items entered gt;
wrote
gt; gt; in message ...
gt; gt; gt; I enter orders we receive for our business. I list them down in a
column,
gt; gt; is
gt; gt; gt; there anyway I can tell if I have entered one more than once without
gt; gt; having
gt; gt; gt; to go back and check every time?
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;
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 Dquot;Bob Phillipsquot; wrote:

gt; Do want to expand on that? What did happen?
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;items entered twicequot; gt; wrote in
gt; message ...
gt; gt; i'm sorry i tried that and it wouldn't work correctly
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; You could use conditional formatting, with a formula of say
gt; gt; gt; =COUNTIF(B:B,B1)gt;1. This will then highlight them both as you enter it.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove xxx from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;items entered twicequot; lt;items entered gt;
gt; wrote
gt; gt; gt; in message ...
gt; gt; gt; gt; I enter orders we receive for our business. I list them down in a
gt; column,
gt; gt; gt; is
gt; gt; gt; gt; there anyway I can tell if I have entered one more than once without
gt; gt; gt; having
gt; gt; gt; gt; to go back and check every time?
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

I suggested adding it in Conditional Formatting, not in a worksheet. To do
so, select your column (say column B), goto Formatgt;Conditional Formatting,
change Condition 1 to Formula Is, and add that formula. Click Format, select
Pattern, choose a colour, then OK.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;items entered twicequot; gt; wrote in
message ...
gt; FALSE popped up I put the correct letters in place of the ones you had in
gt; there and it still didn't respnded correctly. Here is an example of what
the
gt; numbers look like that i key in 239089
gt; 694185
gt; 276784 All of which are keyed in column D
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Do want to expand on that? What did happen?
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove xxx from email address if mailing direct)
gt; gt;
gt; gt; quot;items entered twicequot; gt;
wrote in
gt; gt; message ...
gt; gt; gt; i'm sorry i tried that and it wouldn't work correctly
gt; gt; gt;
gt; gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You could use conditional formatting, with a formula of say
gt; gt; gt; gt; =COUNTIF(B:B,B1)gt;1. This will then highlight them both as you enter
it.
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; Bob Phillips
gt; gt; gt; gt;
gt; gt; gt; gt; (remove xxx from email address if mailing direct)
gt; gt; gt; gt;
gt; gt; gt; gt; quot;items entered twicequot; lt;items entered
gt;
gt; gt; wrote
gt; gt; gt; gt; in message
...
gt; gt; gt; gt; gt; I enter orders we receive for our business. I list them down in a
gt; gt; column,
gt; gt; gt; gt; is
gt; gt; gt; gt; gt; there anyway I can tell if I have entered one more than once
without
gt; gt; gt; gt; having
gt; gt; gt; gt; gt; to go back and check every time?
gt; gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;