MrExcel's Learn Excel #927 - Pivot Table for Worksheet Comparison

This tutorial demonstrates how to compare two worksheets using a pivot table, continuing with Jim's question about matching data across sheets based on a common column.

MrExcel's Learn Excel #927 - Pivot Table for Worksheet Comparison
Bill Jelen
292 views • Jan 13, 2009
MrExcel's Learn Excel #927 - Pivot Table for Worksheet Comparison

About this video

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!

Video Information

Views

292

Duration

3:48

Published

Jan 13, 2009

Related Trending Topics

LIVE TRENDS

Related trending topics. Click any trend to explore more videos.