![]() Take for example the monthly sales lists for a series of products. This can be problematic as you have to consider differences in the comparator fields or risk producing misleading analysis. I regularly see people using vlookups to compare two sources of data. Why VLOOKUP is not the best way to compare data sources ![]() In this tutorial I will demonstrate why you should add pivot table comparisons to your data analysis toolbox and forget about the inferior vlookup function. An easy and risk-free way to compare data from two or more sources is by using a pivot table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |