identify duplicate data in excel spreadsheet

Please help me to identify duplicate data from excel spreadsheet.
I have to enter series of five digit numbers in spreadsheet as per work
completion.....and some time it so happens that the same number is entered
twice......I want that the excel should prompt that the number is already
eneterd.
For example:
35851
35933
36009
35851 (out here this number is duplicate as the same is already entered
above and I want excel should prompt duplicate here)

Assuming that the 2nd entry in your list is at A3,
put this formula in B3 and copy down to suit.

=IF(ISNA(MATCH($A3,$A$2:$A2,0)),"","Duplicate Number!!!!")

Rgds,
ScottO

"Mandeep Dhami" <Mandeep [email protected]> wrote in
message news:[email protected]...
| Please help me to identify duplicate data from excel spreadsheet.
| I have to enter series of five digit numbers in spreadsheet as per
work
| completion.....and some time it so happens that the same number is
entered
| twice......I want that the excel should prompt that the number is
already
| eneterd.
| For example:
| 35851
| 35933
| 36009
| 35851 (out here this number is duplicate as the same is already
entered
| above and I want excel should prompt duplicate here)
|

If you want to keep duplicates from being entered, see
http://www.contextures.com/xlDataVal07.html

--
Good Luck,
Peg


"Mandeep Dhami" wrote:

> Please help me to identify duplicate data from excel spreadsheet.
> I have to enter series of five digit numbers in spreadsheet as per work
> completion.....and some time it so happens that the same number is entered
> twice......I want that the excel should prompt that the number is already
> eneterd.
> For example:
> 35851
> 35933
> 36009
> 35851 (out here this number is duplicate as the same is already entered
> above and I want excel should prompt duplicate here)
>

Thanks a lot Peg....your suggetion at the site indicated by you solved my
problem.

"PegL" wrote:

> If you want to keep duplicates from being entered, see
> http://www.contextures.com/xlDataVal07.html
>
> --
> Good Luck,
> Peg
>
>
> "Mandeep Dhami" wrote:
>
> > Please help me to identify duplicate data from excel spreadsheet.
> > I have to enter series of five digit numbers in spreadsheet as per work
> > completion.....and some time it so happens that the same number is entered
> > twice......I want that the excel should prompt that the number is already
> > eneterd.
> > For example:
> > 35851
> > 35933
> > 36009
> > 35851 (out here this number is duplicate as the same is already entered
> > above and I want excel should prompt duplicate here)
> >