Results 1 to 2 of 2

combine & remove duplicate part number

Threaded View

  1. 08-19-2013, 05:15 PM #1
    integra
    integra is offline
    Registered User
    Join Date
    07-07-2009
    Location
    Orange County, California
    MS-Off Ver
    Microsoft 365; Excel 2010
    Posts
    40

    combine & remove duplicate part number

    i have two sets of data and i would like to combine into one.
    Problem is some may have duplicated part number.
    my current method is copy & paste data from 2 different tab in to one and using data, remove duplicated to get what i needed
    just wondering if there is a better way to have it done by formula w/out using code
    any suggestion is appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 PM
  2. How Do I Combine Different Cell Data in Column B with one single Part Number in Column A
    By leadfeet in forum Excel General
    Replies: 7
    Last Post: 10-23-2012, 02:29 PM
  3. Find Part number through Macro and output to associated part to certain cell
    By boylers75 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 04:32 PM
  4. [SOLVED] Remove duplicate entries based on unique number Excel 2000
    By IM22 in forum Excel General
    Replies: 7
    Last Post: 04-09-2012, 01:56 PM
  5. How to combine Excel 2002 files and remove duplicate records?
    By Dave542 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-06-2006, 08:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1