International
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!
Rated 3.80 | 299 Views
By MrExcel
Rated 3.67 | 254 Views
By MrExcel
Rated 3.57 | 1,408 Views
By MrExcel
Pivot Sorting - 1059 - Learn Excel from Mr...Excel
Rated 3.59 | 321 Views
By MrExcel
MrExcel's Learn Excel #950 - Sponsored by...MrExcel.com Store
Rated 3.64 | 568 Views
By MrExcel
MrExcel's Learn Excel #970 - Missing Months
Rated 3.68 | 1,116 Views
By MrExcel
MrExcel's Learn Excel #975 - Excel Gemini
Rated 3.49 | 788 Views
By MrExcel
WIIW - Classic Pivot Layout - 1058 - Learn...Excel Podcast
Rated 3.96 | 156 Views
By MrExcel
MrExcel's Learn Excel #928 - WIIW - Multip...le Consolidation
Rated 4.00 | 936 Views
By MrExcel
MrExcel's Learn Excel #948 - Reverse Chart...Axis
Rated 3.99 | 159 Views
By MrExcel
Generalize Recorded Macro - 1028 - Learn E...xcel from MrExcel
Rated 3.63 | 1,666 Views
By MrExcel
Fabien PivotTable - 1105 - Learn Excel fro...m MrExcel Podcast
Rated 4.91 | 31 Views
By MrExcel
Love GetPivotData? - 1128 - Learn Excel fr...om MrExcel
Rated 0.00 | 12 Views
By MrExcel
Learn Excel from MrExcel Episode 912 - Piv...ot Rates
Rated 3.98 | 673 Views
By MrExcel
Learn Excel from MrExcel Episode 913 - Piv...ot Rates II
Rated 3.97 | 245 Views
By MrExcel
Replicate Pivot - 1021 - Learn Excel from...MrExcel Podcast
Rated 3.43 | 181 Views
By MrExcel