+ Reply to Thread
Results 1 to 3 of 3

Comparing values

  1. #1
    Dirk_Bob
    Guest

    Comparing values

    I have two sheets in a workbook. The first column in each sheet has part
    numbers.
    I would like to compare worksheet1 column a to worksheet 2 column a and
    identify duplicate values. I have not been able to make this work.
    --
    Dirk

  2. #2
    Registered User
    Join Date
    02-15-2005
    Posts
    29

    Vlookup

    I had the same problem and if you do a vlookup formula, it will be able to show you which ones are duplicated

  3. #3
    Dave Peterson
    Guest

    Re: Comparing values

    Chip Pearson has lots of ways to work with duplicates/uniques at:
    http://www.cpearson.com/excel/duplicat.htm

    Dirk_Bob wrote:
    >
    > I have two sheets in a workbook. The first column in each sheet has part
    > numbers.
    > I would like to compare worksheet1 column a to worksheet 2 column a and
    > identify duplicate values. I have not been able to make this work.
    > --
    > Dirk


    --

    Dave Peterson

+ 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