Depending what you want, there are a couple different options here. If you
want to prevent duplicate entries, you can use Data Validation.

1. Select the column (A for this example)
2. Select "Data"
3. Select "Validation"
4. Where is says "Allow", choose "Custom"
5. Where is says "Formula", enter: =countif(A:A,A1)=1
6. Click "OK"

If you'd rather allow duplicates to be entered, but just highlight where
they are, you can use Conditional Formatting.

1. Select the column (A for this example)
2. Select "Format"
3. Select "Conditional Formatting"
4. Change the first drop-down box to "Formula Is"
5. Enter the formula: =countif(A:A,A1)1
6. Select the type of formatting you want (i.e. Bold, red letters,
different background, etc...)
7. Click "OK"

HTH,
Elkar



"JENNYC" wrote:


Hi! i have a spreadsheet that is accessed by 12 different users all day.
in column A we enter stock numbers. Is there a way to have Excel let me
know if there are ever duplicate stock numbers entered? i can insert
new columns to do this...just not sure what formulas i would use to do
that?? any help is greatlly appreciated!!

thanks in advance!


--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579
View this thread: http://www.excelforum.com/showthread...hreadid=481999