Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight or Mark any values in a column that are duplicates insidethe column | Excel Programming | |||
How can I count dates if few duplicates in a column | Excel Discussion (Misc queries) | |||
Counting Cells in a column depending on another column but excluding duplicates | Excel Discussion (Misc queries) | |||
Format time column to remove dates | Excel Discussion (Misc queries) | |||
Remove Duplicates Based on more than one column | Excel Programming |