ReePrime
Blog DMC
MrExcel's Learn Excel #927 - Pivot Compare

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

MrExcel's Learn Excel #927 - Pivot Compare

B
Bill Jelen

1 Views • Jan 13, 2009

Description

Match two worksheets using a pivot table. We continue on this week with Jim's question about matching two worksheets with a common column. Rather than using VLOOKUP, you can use a pivot table to do the comparison. Episode 927 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Keywords & Tags

#excel #business #accounting #spreadsheets #tutorial #technology #mrexcel #pivot #table #matching

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

00:05

[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets

Mingdestiny

00:05

Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets

Boziek

09:14

How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel

Alonza Darrick

01:26

How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets

HotHotSoftware1

00:28

PDF Excel for Auditors Audit Spreadsheets Using Excel 97 through Excel 2007 Download Full Ebook

Reyna

03:09

How to extract e-mail addresses from Excel Spreadsheets (or multiple excel files)

HotHotSoftware1