BrutalDawg
02-13-2017, 07:51 AM
Good morning,
I have a situation where I am trying to remove only the older of duplicate rows. Matching Duplicates would be based on three criteria, Column A which is text, column D which is text, and column G which is formatted as mm/dd/yyyy. Column B would decide which is older formatted as mm/dd/yyyy. Such As
Ohio
1/29/2017
1001
81241
Firm
120
2/7/2017
Delete
Ohio
2/1/2017
1001
81241
Firm
135
2/7/2017
Leave
GA
1/29/2017
1002
81241
Firm
50
2/7/2017
Delete
GA
1/29/2017
1002
81340
Firm
50
2/7/2017
Leave
GA
2/1/2017
1002
81241
Firm
55
2/7/2017
Leave
GA
2/1/2017
1002
81340
Firm
50
2/14/2017
Leave
GA
1/29/2017
1002
81241
Firm
100
2/14/2017
Leave
Ohio
2/1/2017
1001
81241
Firm
100
2/14/2017
Leave
Any ideas?
I have a situation where I am trying to remove only the older of duplicate rows. Matching Duplicates would be based on three criteria, Column A which is text, column D which is text, and column G which is formatted as mm/dd/yyyy. Column B would decide which is older formatted as mm/dd/yyyy. Such As
Ohio
1/29/2017
1001
81241
Firm
120
2/7/2017
Delete
Ohio
2/1/2017
1001
81241
Firm
135
2/7/2017
Leave
GA
1/29/2017
1002
81241
Firm
50
2/7/2017
Delete
GA
1/29/2017
1002
81340
Firm
50
2/7/2017
Leave
GA
2/1/2017
1002
81241
Firm
55
2/7/2017
Leave
GA
2/1/2017
1002
81340
Firm
50
2/14/2017
Leave
GA
1/29/2017
1002
81241
Firm
100
2/14/2017
Leave
Ohio
2/1/2017
1001
81241
Firm
100
2/14/2017
Leave
Any ideas?