Extract Customer Names, Not in Master Lists with Power Query - Excel Magic Trick 1599

preview_player
Показать описание
Learn how to Compare Two Lists and extract customer names that are in List 2 that are not in List 1using Power Query. See how to use the Merge feature, and the join operation; Left-Anti Join. Also see how to extract items in both lists using a Inner Join.
Related Video:
MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples
  1. excelisfun
  2. Excel
  3. Highline College
  4. Mike Girvin
  5. excelisfun
  6. EMT
Рекомендации по теме
Extract Customer Names, 0:03:53

Extract Customer Names, Not in Master Lists with Power Query - Excel Magic Trick 1599

Extract Customer Names, 0:05:06

Extract Customer Names, Not in Master Lists with Advanced Filter - Excel Magic Trick 1598

Compare Two Lists, 0:09:47

Compare Two Lists, Extract Customers Not in Both: Excel Formulas or Power Query; EMT 1811

Extract First, Middle 0:00:50

Extract First, Middle & Last Names from a list of Names in Microsoft Excel

VLookUp - How 0:05:53

VLookUp - How To Extract Data From an Excel Spreadsheet Given Customer ID Number

Excel Magic Trick 0:27:23

Excel Magic Trick 1446: Power Query Count & Extract Customer Names for 8 Sales Coupon Groups

Compare Two Lists 0:08:10

Compare Two Lists & Extract Matching / Common Names in Separate Column, Unique Match Names in Ex...

Excel Formula to 0:03:40

Excel Formula to Extract Items from Two Lists - Excel Magic Trick 1597. Is Item NOT in List?

Excel Pro Tip: 0:00:31

Excel Pro Tip: How to Easily Extract Numbers from Cells

How to Extract 0:15:54

How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

Excel Trick 15 0:01:00

Excel Trick 15 - Extract Middle Name from Inconsistent Full Name With Flash Fill #shorts

How to Extract 0:07:02

How to Extract Last Name in Excel (3 Easy Ways) | No Formula Used

extract unique characters 0:08:27

extract unique characters | extract unique names from column excel dynamic| EXCEL

Excel Magic Trick 0:22:32

Excel Magic Trick 1226: Compare 2 Lists, Extract Items In List 2 That are NOT in List 1 (6 Examples)

Extract Data Based 0:08:13

Extract Data Based on a Drop Down List Selection in Excel | Filter Data With Drop Down List Excel

Excel Magic Trick 0:05:52

Excel Magic Trick 1441 Power Query to Extract Items In List 1 That Are NOT In List 2: Left Anti Join

Excel 2013 Preview 0:02:11

Excel 2013 Preview #2: Flash Fill To Extract First & Last Names From Column (Excel Magic Trick 9...

Excel Magic Trick 0:30:33

Excel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Grou...

How to Extract 0:03:11

How to Extract Multiple Matching Records in Excel in simple way

Extract a List 0:15:44

Extract a List of Worksheet Names Using Functions - With 2 ways Navigation

Extract First, Last 0:06:14

Extract First, Last & Middle Name Excel Power Query

How to automate 0:01:37

How to automate extracting text from emails in just 1 minute

Excel Magic Trick 0:18:24

Excel Magic Trick 1372: Extract Only Total Row For Each Name: Formula or Power Query (6 Examples)

Compare Multiple Lists 0:01:36

Compare Multiple Lists & Extract Matching / Common Names in Separate Column in Microsoft Excel

Комментарии
Автор

Easy PQ solution. I do not personally have a lot if PQ applications but I use merges and joins regularly for easy fun!!! I agree with you that AF is the best way when data is in Excel but I often look for good PQ applications just for practice.

richardhay
Автор

Thanks Mike for all these EXCELlent videos. They definitely help a lot of people out there.

SyedMuzammilMahasanShahi
Автор

Just gotta love PowerQuery for the flexibility (bonus tip!) of the different joins (or "lookups")!

DougHExcel
Автор

Great. We love Power Query. Can't think how we managed without it. Thanks a lot for all you to do help us improve and get more effective!

EricaDyson
Автор

Sir, you are the best Excel trainer ever ! Thank you so much! This trick helps me a lot with data comparing and extracting. Thank you for thousands times

albertaassociationofimmigr
Автор

Another great way to solve this problem Mike. Thank you for share all them.

enriquedominguez
Автор

Power Query the Great, Thanks You so much Mr. Mike

ogwalfrancis
Автор

Great example of using merge to filter the table. Thanks :-)

BillSzysz
Автор

Hi Mike.. thanks for the PQ fun merging lists to extract the data you want. Will check out MSPTDA 07 to get the full experience with PQ Merge and Join, as well as your great business examples. Super fun!! Thumbs up!!

wayneedmondson
Автор

Among all the solutions, PQ is my favourite:):)

sherryizzie
Автор

Hi Mike..this is what I am looking for, it's very helpful and make my tasks easier!!

iwantovani
Автор

Great video and bonus top Mike! Thanks!

chrism
Автор

I just started a new job yesterday where the department I work in do lots of statistical analysis using Excel. Sadly, they are currently only using Excel 2016. This has Get & Transform, but doesn't seem to be as flexible as the 365 version. For example, there doesn't seem to be a PQ Add-In available or icon in the Data tab.

Is this normal for that version Mike?

By the way, great video as always.

Alan

alanmonaghan
Автор

Thanks Mike. Something off the be seeing videos on the XLookup and Xmatch??

johnborg
Автор

How to lookup item image from one sheet to another sheet2 through item id or item code?

usmanhafeez
Автор

Hi mike, , how can i extract customer names who not buying certain item products within raw data ? Hope you can help, , thanks

MrTuakak
Автор

AMAZING. Just Got them! Over night (Wednesday night) XLOOKUP and XMATCH magically showed up--3 days later than MS had "promised" me on the phone!! Will definitely road-test them today!!

richardhay