+ Reply to Thread
Results 1 to 8 of 8

Duplicate Dates in Different Columns

  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    12

    Duplicate Dates in Different Columns

    Dear All,

    I have 5 sets of data all with their individual Date ranges.

    How can I please align all the columns (both Date and Data) so I keep all the same dates and remove the ones which do not match in all columns?

    Please see attachment for further help.

    i.e. Columns A, D, G, J and M are the date ranges and I'd like to align all of these so all columns have the same dates and I can align the data.

    Pls advise.

    Cheers!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-21-2013
    Location
    denmark
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Duplicate Dates in Different Columns

    Hi Mate I'm really not sure what you want here I'm looking at your sheet so can you try to explain in another way..

    What I understand from what you are saying is that if column A-D-G-J have the same dates in the row but M doesn't then you want it to remove M in that row with the date that is linked with the M date?

  3. #3
    Registered User
    Join Date
    05-28-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Duplicate Dates in Different Columns

    Hi there,

    Thanks for responding.

    I have 5 data sets and want to align all 5 sets so they each have identical date ranges so will neatly align and finish at the same row i.e. that means removing all unique dates as well as dates which are represented in say for example 3 sets but not the remaining 2 sets.

    I hope that makes sense.

  4. #4
    Registered User
    Join Date
    03-21-2013
    Location
    denmark
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Duplicate Dates in Different Columns

    try to see in sheet2 if that is what you mean (this is without vba)
    Attached Files Attached Files

  5. #5
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Duplicate Dates in Different Columns

    Hi, Check it out the attachment


    Does that help ?
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  6. #6
    Registered User
    Join Date
    05-28-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Duplicate Dates in Different Columns

    lafanker thanks for your help but that's not quite the solution.

    boopathiraja you have got it perfectly. I would love to know how you managed to do this? I'm looking at the different tabs and it looks as though you've done some sort of pivot table???

  7. #7
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Duplicate Dates in Different Columns

    Used Pivot table with Multiple Consolidation Ranges

    You may also refer the below link

    http://www.contextures.com/xlPivot08.html

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Duplicate Dates in Different Columns

    If you are open to a VBA solution, please find the attached sheet and click on the Green Button to Align the Data and get the desired output on Sheet3.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] formula to list dates in a table (Listing duplicate dates only once)
    By JRidge in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-11-2013, 03:53 AM
  2. Counting number of unique dates per month in a list of duplicate dates
    By Rackle83 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-22-2013, 10:15 AM
  3. Replies: 4
    Last Post: 02-02-2012, 09:24 AM
  4. Find duplicate info in two columns and copy info from duplicate rows
    By USGS in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-12-2011, 07:31 PM
  5. dates in multiple columns/ranges to be copied and sorted with no duplicate values
    By mpreddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2007, 09:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1