View Single Post
  #1   Report Post  
spamdavy spamdavy is offline
Junior Member
 
Posts: 5
Default Remove duplicates in one column within a range of dates in another column

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