Results 1 to 4 of 4

Comparing ranges to see if duplicate values occur

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2202 (Build 14931.20858 Click-to-Run)
    Posts
    51

    Comparing ranges to see if duplicate values occur

    Hi guys,

    I've attached file. I've two sheets, each with panels from new and old aicraft type. In the new panels there are values such as '151EZ' that is not in the old panels sheet.

    I need a list of all the new panels and was wondering if there is a quicker way of doing this as there are 950 old panels to check.

    Regards,

    FP
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Counting if two ranges occur between two times
    By elleb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-04-2018, 06:19 PM
  2. Macro to add row if duplicate occur in a data table
    By JonesyCC in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2017, 10:21 AM
  3. Comparing values within separate ranges in the same worksheet
    By Excellent89 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-21-2015, 07:10 PM
  4. Replies: 3
    Last Post: 11-26-2014, 07:12 AM
  5. Replies: 1
    Last Post: 08-02-2013, 09:58 PM
  6. Replies: 3
    Last Post: 06-25-2011, 06:42 AM
  7. Comparing two ranges and extracting non duplicate data
    By Knut Dahl in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-26-2005, 09:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1