Excel Hack 54: The Data Clean Up Function Squad
For many data analysts, a significant part of daily work is spent cleaning collated data in preparation for further analysis. When receiving data from multiple users and sources, there is a high likelihood of finding anomalies, discrepancies and plain errors (“dirty data”) that need to be rectified if any real analysis and insights can be