Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » General » Find common records between multiple data sets

Find common records between multiple data sets

Previous | Next
Latest post Wed, Jun 30 2010 9:54 PM by Jim Cone. 1 replies.

  • Wed, Jun 30 2010 2:45 PM

    Find common records between multiple data sets

    Reply |Contact

    Hi,

    I would like to find common or duplicate records between 8 data sets (each one has different number of records). I have found this formula =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1) which works great between two data sets. How can I modify it to include all 8 sets? Or do I need a different formula?


    I am an average excel user. Any help is greatly appreciated.

    Regards,

    Patricia

     
    Filed under:
    • Post Points: 21

  • Wed, Jun 30 2010 9:54 PM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 233
    • Points 3,315

    Re: Find common records between multiple data sets

    Reply |Contact |Mark as Answer


    You could paste all data sets into a single column and use a Match formula or filter the column.
    '--
    Jim Cone
    Portland, Oregon USA
    http://tinyurl.com/XLCompanion
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.