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)