very urgent

[mangesh]

hi
suppose i have entered a number or a text in a column, if i again r
enter the same number or text in that column excel should warn me tha
data is already exist.

for example
in column A1 i have entered 125 and suppose if i again enter 125 i
cell A2, excel should warn me its already exist

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/NoDupEntry.htm
for a procedure to prevent duplicates

 

[Norman Harker]

Hi Mangesh!

See:

Chip Pearson:
http://www.cpearson.com/excel/NoDupEntry.htm

Chip uses a Data Validation formula of:

=COUNTIF($A$1:$A$50,A1)=1

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.