Highlight & Delete Duplicate Rows

If you are working with large data size with numerous data fields, there could be duplicate records in data which needs to highlighted and corrected to make data more meaningful and usable.

In example below (See picture 1), we have ROW number 2 and 7 which are duplicate and needs to be highlighted.

This can done using 2 simple formulas - CONCATENATE and COUNTIF

Introduction to data analysis & visualization through excel

With the advent of cheap computation power (PC), the amount of data and related graphs/charts & info-graphics has seen a tremendous growth in last few decades.  While there are hundreds of specialized tools available in the market, excel remains the most widely used tool due to its mass reach.

Excel provides a great set of tools for data analysis and visualizations. With a bit of creativity & efforts it can be extended beyond the obvious uses to produce stunning results.