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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove duplicates in one column within a range of dates inanother column
Davy,
I'd use Advanced Filter. Highlight the range with your data and click DataAdvanced (from the Sort & Filter group). You may either filter the list in place or copy it to a new location in your workbook. Ignore the criteria range,and fill in the "Copy to" range if you are putting the results elsewhere in your book. Finally, be sure to check the box for "Unique records only" and click OK. Hope this helps, Ben |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
|
|||
|
|||
Thanks for the replies!
However, there's one subtle nuance that makes this issue more complex. I'd like to select the values to de-dupe in Column A based on that row's date in Column B. The equivalent manual process is to copy all rows with 9/3 to another sheet and de-dupe Column A. Repeat for different dates 9/4 and 9/5. Is there a more efficient way to do this? btw, I have Excel 2010. Last edited by spamdavy : September 6th 12 at 09:47 PM |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove duplicates in one column within a range of dates in another column
On Thu, 6 Sep 2012 19:33:03 +0000, spamdavy wrote:
Thanks for the replies! However, there's one subtle issue that makes this issue more complex. I'd like to de-dupe Column A as defined by the date in Column B. The equivalent manual process is to copy all rows with 9/3 to another sheet and de-dupe Column A. Repeat for different dates 9/4 and 9/5. Either I am not understanding what you want, or you are not understanding the process I recommend. What happened when you tried the process I recommended? Since the process I recommended compares both columns A & B, it shouldl only dedupe for matches in column A with the same date in column B. There is no need to do this one at a time. If you are still having a problem, please post a copy of a sample file to a publically accessible web site (e.g. Skydrive), and show before and after examples of what you want. Post the link here. |
#6
|
|||
|
|||
Wow, I completely mis-understood what that Remove Duplicates dialog box was asking for. I originally thought it was asking me which column I'd like to de-dup independently of the other selections until you've showed me the light.
Thank you Ron. You've just saved me days, if not weeks of my life! -davy Quote:
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove duplicates in one column within a range of dates in another column
On Fri, 7 Sep 2012 23:55:08 +0000, spamdavy wrote:
Wow, I completely mis-understood what that Remove Duplicates dialog box was asking for. I originally thought it was asking me which column I'd like to de-dup independently of the other selections until you've showed me the light. Thank you Ron. You've just saved me days, if not weeks of my life! Glad to help and happy that you've got it to work for you. Thanks for the feedback. -- Ron |
Reply |
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 |