+ Reply to Thread
Results 1 to 3 of 3

How to extract duplicate records from 4 spreadsheet into a separate spreedsheet?

  1. #1
    Registered User
    Join Date
    08-10-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to extract duplicate records from 4 spreadsheet into a separate spreedsheet?

    Hi Fellows,

    I have 3-4 excel spreadsheets with same sort of data. Each spreadsheet has 1000+ records, and each record has data ranging from column A to Z.
    Some records are duplicate within these 4 spreadsheets. Now, I want to extract the duplicates into new spreadsheet like;

    every record has a unique account number, I want to put a formula against the column which is the account number and it look up that account# in all the spreadsheets and then put the only duplicate records founds into a new spreadsheet from column A-Z (it should only extract the duplicate account numbers found i.e. 2,3 or 4 times duplicate).

    Please if someone could help me out to populate that kind of formula.

    Thank You!

  2. #2
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: How to extract duplicate records from 4 spreadsheet into a separate spreedsheet?

    Hi
    Please upload a sample excel sheet.
    Thanks
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  3. #3
    Registered User
    Join Date
    08-10-2012
    Location
    Islamabad, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: How to extract duplicate records from 4 spreadsheet into a separate spreedsheet?

    Hi,

    I have attached a sample sheet with few records.

    Thanks!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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