This is my first post of blog where I have just posted one image. Later while moving images from one place to another I update this with more details. The post is useful if you are using MS Excel 2003 or below as MS Excel 2007 has option to remove duplicates.
Here we will use countif to determine all unique as 1 and duplicate as 2 or more. Mentioned below is formula to be placed in first row. For details take a look at screenshot/image below.
Formula: =COUNTIF($A$2:A2,A2)
Click on image to view enlarge
Also, you can download file with find duplicate example.
Please do let me know your views and comments about this post and subscribe to us to receive latest updates via email
We assure you knowledge, not SPAM!
0 comments:
Post a Comment