Lets say you have a column full of data in your excel and you want to find out the duplicates in it: Method 1 - Using Countif function Let's say your data is this Column A Siri Sekhar Sahan Sahiti Sahana Siri Sekhar Sekhar Now in Column B enter the formula in the first cell =CountIF($A$1:$A$8, A1) Then sort the data by Column B and you will know which data is repeated Method 2 - Using Pivot Table In Excel 2013, go to Insert --> Pivot Table When asked to select Table or Range, select the Column A data Now when the pivot table fields are shown select the Column A and drag it to "Row Labels" and "Values" - Set "Values" to Count This will give you the count of each of the element thus enabling you to find the duplicates.
Being in the industry for almost two decades, one thing that's been constant is change and my curiosity. I In this fast world of IT...being curious, learning and learning by doing is quintessential :) Here is my way of learning and sharing what I learnt!!! Author: Sirisha Reddy G V