Remove duplicates in one column within a range of dates in another column
On Wed, 5 Sep 2012 17:14:32 +0000, spamdavy wrote:
Hello,
This is how my data is broken down:
Column A - random digits of length 8
Column B - dates (ex. 9/3, 9/4, 9/5)
I'd like to remove duplicates from Column A within a date. Steps a
1) De-dupe the Column A values that have 9/3 in Column B. Do not
consider any data from 9/4 or 9/5 during the dedupe process.
2) Rinse, repeat for 9/4 and 9/5.
How might I go about doing this in an efficient manner?
Thank you for your help in advance!
davy
If you have Excel 2007 or later, there is a "Remove Duplicates" item on the Data menu on the ribbon. It allows you to choose the columns to process. In your case, you would select column A and column B
|