Results 1 to 9 of 9

Crossrefencing table for new data/Unique data

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2018
    Location
    Peshawar, Pakistan
    MS-Off Ver
    MS 2016
    Posts
    4

    Lightbulb Crossrefencing table for new data/Unique data

    Hello All,

    Hope all of You are fine and doing well.

    Well i am facing an issue in cross referencing two table in a workbook, sheet "Clean Data" contains data of trainees who had completed our courses and "New Entry" contains data i extract from our Learner Management System online quiz. What i want is that the when i paste the extracted data in "New Entry", some how i know which data is new and which already exists in our "Cleaned Data".

    The issue is that i can search with the user name column, but some users complete two different sessions over a period of time so i also have to check the reference for "Session Name" in both. What formula of function should i use in Column D of Sheet "New Entry so i get to know new data.

    I am attaching the example excel file of some could help, i would much appreciate it.

    I tried to nest vlookup in IF function but vloopkup on returns 1st occurrence of value so it does not help much, please help me out here.
    Attached Files Attached Files
    Last edited by yousafzai.shoaib; 05-16-2018 at 05:16 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare two tables to create a third table of unique data
    By M-Tommo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-17-2017, 05:17 AM
  2. [SOLVED] Filter data from table that have unique characteristics
    By L.LEE in forum Excel General
    Replies: 7
    Last Post: 09-16-2017, 06:56 AM
  3. [SOLVED] Pull data into a unique table using VBA?
    By ccastell88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2015, 08:31 PM
  4. [SOLVED] Pull data into a unique table?
    By ccastell88 in forum Excel General
    Replies: 3
    Last Post: 08-03-2015, 04:02 AM
  5. Replies: 3
    Last Post: 05-21-2014, 08:34 AM
  6. [SOLVED] Make a Unique List from data table
    By turist in forum Excel General
    Replies: 4
    Last Post: 03-02-2013, 06:08 PM
  7. Replies: 4
    Last Post: 02-14-2008, 12:28 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