P
PA
I have created a formula in column Q which, after filled to the last row of
data identifies all of the duplicates by putting the SSN found in column K,
into the corresponding cell in column Q.
The formula is
=IF(AND(COUNTIF($P$2:$P$1740,P2)>1,COUNTIF($G$2:$G$1740,G2)>1),K2,"")
I need to write some code to delete all duplicates, except one.
Any suggestions are eagerly appreciated.
Paul
data identifies all of the duplicates by putting the SSN found in column K,
into the corresponding cell in column Q.
The formula is
=IF(AND(COUNTIF($P$2:$P$1740,P2)>1,COUNTIF($G$2:$G$1740,G2)>1),K2,"")
I need to write some code to delete all duplicates, except one.
Any suggestions are eagerly appreciated.
Paul