First you need two helper columns -
One column to give each row a number - so that you can at least get it
back to the same order as it started.
One column to contain a formula =IF(a2=a1,1,0) (where column A is
suspected to have duplicated cells)
Sort on the suspicious column
Find any incidents of 1 in the second helper column. This indicates a
duplication.
Regards.
Bill Ridgeway
Computer Solutions
"DLee" wrote in message
...
I have created a database which has been worked on by someone else.
I have made the necessary alterations but how do I check for duplicate
entries on each worksheet.
Thansk
|