software

Hi there guys

Was just wondering - is there a way to get a warning message pop up (or any
kind of warning) if a value is entered in a cell that already exists in
another cell in that column earlier/later? This will enable me to eliminate
entering duplicate values in a cell in a particular column...

Thanks muchly.

Raj

You can use Data Validation to prevent entry of duplicate values.

Select your column (I'll use Column A for this example)
From the Data Menu, select quot;Validationquot;
In the Allow field, select quot;Customquot;
Enter the formula: =COUNTIF(A:A,A1)=1

You can also set custom messages to display if duplicates are entered.

Note, this will only prevent manual entry of data from being duplicated. It
will not find existing duplicates or prevent Copy/Pasting duplicate data.

Another option would be to use Conditional Formatting to highlight cells
that contain duplicates. This would allow you to find existing duplicates
and catch Copy/Pasted data. The same formula above could be used there with
one little change. =COUNTIF(A:A,A1)gt;1

HTH,
Elkar
quot;Raj Mazumdarquot; wrote:

gt; Hi there guys
gt;
gt; Was just wondering - is there a way to get a warning message pop up (or any
gt; kind of warning) if a value is entered in a cell that already exists in
gt; another cell in that column earlier/later? This will enable me to eliminate
gt; entering duplicate values in a cell in a particular column...
gt;
gt; Thanks muchly.
gt;
gt; Raj

Thanks Elkar...

quot;Elkarquot; wrote:

gt; You can use Data Validation to prevent entry of duplicate values.
gt;
gt; Select your column (I'll use Column A for this example)
gt; From the Data Menu, select quot;Validationquot;
gt; In the Allow field, select quot;Customquot;
gt; Enter the formula: =COUNTIF(A:A,A1)=1
gt;
gt; You can also set custom messages to display if duplicates are entered.
gt;
gt; Note, this will only prevent manual entry of data from being duplicated. It
gt; will not find existing duplicates or prevent Copy/Pasting duplicate data.
gt;
gt; Another option would be to use Conditional Formatting to highlight cells
gt; that contain duplicates. This would allow you to find existing duplicates
gt; and catch Copy/Pasted data. The same formula above could be used there with
gt; one little change. =COUNTIF(A:A,A1)gt;1
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt;
gt; quot;Raj Mazumdarquot; wrote:
gt;
gt; gt; Hi there guys
gt; gt;
gt; gt; Was just wondering - is there a way to get a warning message pop up (or any
gt; gt; kind of warning) if a value is entered in a cell that already exists in
gt; gt; another cell in that column earlier/later? This will enable me to eliminate
gt; gt; entering duplicate values in a cell in a particular column...
gt; gt;
gt; gt; Thanks muchly.
gt; gt;
gt; gt; Raj