Sponsored Link

There was an error in this gadget

Sponsored Link

Wednesday, September 10, 2008

Formula to find duplicate records

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

findduplicate

Also, you can download file with find duplicate example.

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