Results 1 to 3 of 3

Unique missing list

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Unique missing list

    Hi,

    I am looking for some help with a formula

    I have a “master” sheet which contains unique codes.

    I also have a “Data Load Template” which the user will edit.

    Would I would like is a formula that will list any codes that appear on the master sheet but not the data load template. E.g. If “ABC” appears on the master sheet but not the load template it would appear on the “missing” sheet. But if the user enters “ABC” on the data load template it would disappear from the “missing sheet”

    Can anyone help please?
    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. [SOLVED] Getting unique list and amount sum by unique list wise - Reg.
    By bala04msw in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 08-28-2016, 12:00 PM
  2. Create unique # of worksheets based on list count with unique names
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2016, 09:51 AM
  3. Removed Missing Reference - Is this unique to workbook or to PC
    By Scoobymoo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2015, 07:03 AM
  4. [SOLVED] create list of unique staff numbers with unique work codes
    By shaz0503 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-01-2013, 08:57 PM
  5. A Missing Unique Combination
    By JTM1200 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-25-2012, 11:46 AM
  6. Replies: 1
    Last Post: 05-30-2012, 06:29 AM
  7. Replies: 7
    Last Post: 05-11-2012, 02:00 PM

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