+ Reply to Thread
Results 1 to 4 of 4

What formula should I use to compare duplicate data between worksh

  1. #1
    genoq
    Guest

    What formula should I use to compare duplicate data between worksh

    I have a workbook with 2 spreadsheets, each with containing a list of part
    numbers. On the second spreadsheet, I want to compare lists and identify
    duplicates from the first list, without changing the sorted order of either
    list. What is the easiest way to flag these duplicates on sheet 2

  2. #2
    Bob Phillips
    Guest

    Re: What formula should I use to compare duplicate data between worksh

    Use a helper column with a formula. Assuming key in column A on Sheet1 and
    Sheet2, then use

    =IF(COUNTIF(Sheet1!A:A,A1)>0,"Duplicate","")

    and copy down

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "genoq" <[email protected]> wrote in message
    news:[email protected]...
    > I have a workbook with 2 spreadsheets, each with containing a list of part
    > numbers. On the second spreadsheet, I want to compare lists and identify
    > duplicates from the first list, without changing the sorted order of

    either
    > list. What is the easiest way to flag these duplicates on sheet 2




  3. #3
    genoq
    Guest

    Re: What formula should I use to compare duplicate data between wo

    Thanks! =) Happy New Year!

    "Bob Phillips" wrote:

    > Use a helper column with a formula. Assuming key in column A on Sheet1 and
    > Sheet2, then use
    >
    > =IF(COUNTIF(Sheet1!A:A,A1)>0,"Duplicate","")
    >
    > and copy down
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "genoq" <[email protected]> wrote in message
    > news:[email protected]...
    > > I have a workbook with 2 spreadsheets, each with containing a list of part
    > > numbers. On the second spreadsheet, I want to compare lists and identify
    > > duplicates from the first list, without changing the sorted order of

    > either
    > > list. What is the easiest way to flag these duplicates on sheet 2

    >
    >
    >


  4. #4
    Aladin Akyurek
    Guest

    Re: What formula should I use to compare duplicate data between worksh

    A fast way of flagging common items (duplicates, as you call it) between
    Sheet2 and Sheet1 would be:

    =--ISNUMBER(MATCH(A1,Sheet1!A:A,0))

    1 means duplicate, 0 not.

    genoq wrote:
    > I have a workbook with 2 spreadsheets, each with containing a list of part
    > numbers. On the second spreadsheet, I want to compare lists and identify
    > duplicates from the first list, without changing the sorted order of either
    > list. What is the easiest way to flag these duplicates on sheet 2


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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