LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight or Mark any values in a column that are duplicates insidethe column magmike[_2_] Excel Programming 1 January 27th 12 02:55 AM
How can I count dates if few duplicates in a column Tariq Aziz Excel Discussion (Misc queries) 3 May 25th 10 05:07 PM
Counting Cells in a column depending on another column but excluding duplicates rwenger Excel Discussion (Misc queries) 0 April 11th 10 01:06 PM
Format time column to remove dates rory_r[_2_] Excel Discussion (Misc queries) 4 January 23rd 09 03:48 PM
Remove Duplicates Based on more than one column Michelle Excel Programming 2 July 14th 07 01:45 AM


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"