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.

it is not necessary to quote whole post

you didn't show what you want to achieve. description is a little enigmatic

• load two tables CleanData & NewEntry into PowerQuery
• you will see there Table1 and Table2
• merge these tables by Username
• Extract column Table2 with Session name
• remove unnecessary columns so Session name, username and Session name.1 will stay
• add conditional column (here: Custom) with True (if Session name = Session name.1) and False (if Session name <> Session name.1)
• sort A-Z column username
• load result into the sheet

hope I didn't forget anything

the rest you can do with table in the sheet

---
if new data arrive paste into the table NewEntry then refresh green table

Please Login or Register  to view this content.