+ Reply to Thread
Results 1 to 6 of 6

Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

  1. #1
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

    The attached is a sample of large database that has some duplicates. My original data has already been uploaded in mainframe. I want to find those that are not duplicate Incident numbers so that I can move them to new spreadsheet with same column headings. And then I can upload them. I have windows 10 and excel 2016.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

    Array Formula to list unique values:

    =IFERROR(INDEX($A$3:$A$107,MATCH(1,(COUNTIF(J$2:J2,$A$3:$A$107)=0)*($A$3:$A$107<>""),0)),"")
    Confirm by pressing ctrl+shift+enter.

  4. #4
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Re: Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

    I should have been more clear. I need all the data in each column where the Incident number is not a duplicate. Like this example with data in each cell in the column:
    Incident Code Description Date Time Address
    xxxxx xxx xxxxxxxx xxx xxx xxxx

    The x's are being use as examples only and not to be in the actual cell. Thanks

  5. #5
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365
    Posts
    1,219

    Re: Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

    In new spreadsheet:

    Array enter:

    A2=IFERROR(INDEX(Sheet1!$A$3:$A$107,MATCH(1,(COUNT.IF(A$1:A1,Sheet1!$A$3:$A$107)=0)*(Sheet1!$A$3:$A$107<>""),0)),"")

    Then:

    B2=IFERROR(INDEX(Sheet1!B3:B107,MATCH($A2,Sheet1!$A$3:$A$107,0)),"")
    Copy across to all columns.

    Then copy all columns down.

  6. #6
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    490

    Re: Large data base with some duplicates Need to pull non-duplicates into new spreadsheet

    thank you.

+ 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. Replies: 10
    Last Post: 10-07-2017, 02:46 PM
  2. Large Data base, need to sift through and find duplicates to find x.
    By granger42.t in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2015, 03:09 AM
  3. Large Data base, need to sift through and find duplicates to find x.
    By granger42.t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2015, 10:32 PM
  4. Need to pull address ranges with accompanying data for large data base
    By pick44 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-09-2015, 11:12 AM
  5. [SOLVED] Problem Using LARGE formula with Index/Match to pull values when there are Duplicates
    By BDavis in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-11-2014, 02:23 PM
  6. Make a list of exact match duplicates in large spreadsheet
    By jonnygun in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-29-2013, 12:58 PM
  7. Match/Large with Duplicates (I want to include the duplicates)
    By Willie68 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 01:10 PM

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