I am trying to remove duplicates having variable information.
- Column F = delete time
- Column Q = recipient code
- Column R = recipient address
I need to remove duplicates that match on row information. What defines a duplicate is column F, which can vary by up to 15 minutes. The difficulty for me is that there are hundreds of line items that match Column Q & R. So I sort by column F and then I am forced to look line-item by line-item at columns Q & R, which is very time consuming. Any help is greatly appreciated!