+ Reply to Thread
Results 1 to 3 of 3

Lookup Help: Duplicates with multiple criteria

Hybrid View

  1. #1
    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

+ 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