+ Reply to Thread
Results 1 to 3 of 3

Lookup Help: Duplicates with multiple criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    Chicago
    MS-Off Ver
    Excel 2003
    Posts
    2

    Lookup Help: Duplicates with multiple criteria

    Smart People,
    I need your help. I have a bunch of data kinda like this...

    A1 B1
    Chevy Red
    Chevy Blue
    Chevy Red
    Ford Blue
    Ford Red
    Ford Green
    Ford Green
    Dodge Red
    Dodge Green
    Dodge Green

    I need to remove the duplicates in column B but based on both columns. So it will look like this...

    A1 B1
    Chevy Red
    Chevy Blue
    Ford Blue
    Ford Red
    Ford Green
    Dodge Red
    Dodge Green

    Thanks!!

    DXZ

  2. #2
    Registered User
    Join Date
    01-09-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: Lookup Help: Duplicates with multiple criteria

    Hey mate, I have a way, whether or not it's exactly what you're after is another thing.

    Basically created a helper column with formula that summarises both columns, then ran a conditional format which highlightes duplicates. You just then have to remove the duplicates.

    Apologies if I'm off the mark.
    Attached Files Attached Files

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Lookup Help: Duplicates with multiple criteria

    Select both columns, Data > Remove duplicates, ...
    Entia non sunt multiplicanda sine necessitate

+ 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. [SOLVED] LOOKUP multiple results but ignore duplicates.
    By vane0326 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-09-2013, 02:31 PM
  2. [SOLVED] Deleting Duplicates Based on Multiple Criteria from Multiple Columns
    By Franklic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2012, 05:31 PM
  3. Deleting multiple duplicates with criteria?
    By lukey2606 in forum Excel General
    Replies: 6
    Last Post: 05-12-2012, 03:08 PM
  4. Excel 2007 : Removing duplicates using multiple criteria
    By Rhinoceros77 in forum Excel General
    Replies: 0
    Last Post: 01-23-2012, 11:33 AM
  5. [SOLVED] Lookup with multiple results, without duplicates
    By Rothman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2006, 05:30 PM

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