software

First of all a happy happy Holiday greetings from a grateful reader here.
You guys are the best.....I'm wondering if it is possible, if Excel can
notify me if I enter a duplicate number into a cell. I need to enter serial
numbers of inventory, and sometimes I get my sheets mixed up, and enter the
same info again. Can that be avoided??????

PeterM Wrote:
gt; First of all a happy happy Holiday greetings from a grateful reader
gt; here.
gt; You guys are the best.....I'm wondering if it is possible, if Excel
gt; can
gt; notify me if I enter a duplicate number into a cell. I need to enter
gt; serial
gt; numbers of inventory, and sometimes I get my sheets mixed up, and enter
gt; the
gt; same info again. Can that be avoided??????You can do this to prevent duplicate entries in a column:

1. Select a range where entries will be made (e.g., Cells A1:A500)
2. Go to Data/Validation/Custom
3. Enter this formula =countif($A$1:A500,A1)=1
4. Select quot;Error Alertquot; tab and enter any appropriate message

Regards.--
BenjieLop------------------------------------------------------------------------
BenjieLop's Profile: www.excelforum.com/member.php...oamp;userid=11019
View this thread: www.excelforum.com/showthread...hreadid=494944....another way to do it would be conditional formatting. In the second cell
from the top, go to quot;Formatquot; then quot;Conditional Formattingquot;. Change the drop
down from quot;Cell isquot; to quot;Formula isquot; then type =A2=A1 and choose a format
(highlight yellow or something). Then copy A2 and Paste Special...Formats
as far down the page as you need to. You can then occasionally sort you
serial numbers and duplicates will highlight yellow.

quot;PeterMquot; wrote:

gt; First of all a happy happy Holiday greetings from a grateful reader here.
gt; You guys are the best.....I'm wondering if it is possible, if Excel can
gt; notify me if I enter a duplicate number into a cell. I need to enter serial
gt; numbers of inventory, and sometimes I get my sheets mixed up, and enter the
gt; same info again. Can that be avoided??????
gt;
gt;
gt;