how to restrict the old number already entered

[mangesh]

hi
i have entered a value in a column , if i again re-enter the same value
excel should warn me.

actually i have already sent the same query and i recd. ans for the
same,earlier it was working properly but now its not working plz can
you help me again.

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/NoDupEntry.htm

 

[Norman Harker]

Hi Mangesh!

The answer sent earlier was:

See:

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

Chip uses a Data Validation formula of:

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

You'll need to adjust the formula for the range that you are dealing
with.

--
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.