I have a worksheet with duplicate data in columns A:K, however I have additional data in the colums L:Z. I want to loop through the range and if there are duplicates (column A would be the best to evaluate dups on) then I want to keep the first record and clear the remaining dup selection.
Thanks in advance for any help!
Example (original data) columns A:K
ROWID Name DOB Member ID Order Date Process Date Fulfill Date Part Billed Paid Balance
1 John Smith 1/1/2011 2111 2/1/2013 2/1/2013 2/3/2013 Tire 150.00 100.00 50.00
1 John Smith 1/1/2011 2111 2/1/2013 2/1/2013 2/3/2013 Tire 150.00 100.00 50.00
2 Mary Rose 2/1/2009 3222 3/1/2013 3/1/2013 3/3/2013 Wheel 200.00 125.00 75.00
2 Mary Rose 2/1/2009 3222 3/1/2013 3/1/2013 3/3/2013 Wheel 200.00 125.00 75.00
Example After:
ROWID Name DOB Member ID Order Date Process Date Fulfill Date Part Billed Paid Balance
1 John Smith 1/1/2011 2111 2/1/2013 2/1/2013 2/3/2013 Tire 150.00 100.00 50.00
2 Mary Rose 2/1/2009 3222 3/1/2013 3/1/2013 3/3/2013 Wheel 200.00 125.00 75.00
Thanks in advance for any help!
Example (original data) columns A:K
ROWID Name DOB Member ID Order Date Process Date Fulfill Date Part Billed Paid Balance
1 John Smith 1/1/2011 2111 2/1/2013 2/1/2013 2/3/2013 Tire 150.00 100.00 50.00
1 John Smith 1/1/2011 2111 2/1/2013 2/1/2013 2/3/2013 Tire 150.00 100.00 50.00
2 Mary Rose 2/1/2009 3222 3/1/2013 3/1/2013 3/3/2013 Wheel 200.00 125.00 75.00
2 Mary Rose 2/1/2009 3222 3/1/2013 3/1/2013 3/3/2013 Wheel 200.00 125.00 75.00
Example After:
ROWID Name DOB Member ID Order Date Process Date Fulfill Date Part Billed Paid Balance
1 John Smith 1/1/2011 2111 2/1/2013 2/1/2013 2/3/2013 Tire 150.00 100.00 50.00
2 Mary Rose 2/1/2009 3222 3/1/2013 3/1/2013 3/3/2013 Wheel 200.00 125.00 75.00