|
To identify duplicate entries in Column B (as compared to entries in Column A), you can use this formula:
=if(countif($A$1:$A$2000,B1)>0,"Duplicate","")
Enter the above formula in Cell C1 and copy down.
Now that you have identified the duplicate entries, you can then decide what to do with them.
Hope this helps you.
Regards.
__________________
BenjieLop
Houston, TX
Last edited by BenjieLop; 06-07-2005 at 12:00 PM.
|