Comprehensive video showing very useful ways of using VLOOKUP. Explains when to use Range Lookup with easy examples.
Learn why in this short, 5-minute video.
More articles on VLOOKUP are here
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or for correcting spelling mistakes. If new items appear, they remain ungrouped. That way, you have to keep doing the Grouping update repetitively. An alternative is to use VLOOKUP based text grouping. Read on to find out how this is done.
Now it is time to spell out exactly what to look for when creating good raw data (or repairing bad input data). Use this as a checklist to quickly classify data into GOOD or BAD (requires clean-up).
Photo credit: Flyinace2000 / Foter / CC BY-SA
Analytics is all about summarizing and grouping. Numbers are grouped into bins, text is categorized and dates are compressed into months, quarters and years. This series covers various quick and powerful methods to perform sophisticated grouping in seconds.
Estimated reading time 10 min