Need software to find duplicates in excel worksheets


  1. Posts : 64
    Windows 7
       #1

    Need software to find duplicates in excel worksheets


    Dear All,

    Can you plz suggest me a software that can find duplicate texts present in an excel file? I know there is an option called "Remove Duplicates" under Data section in excel, but it can only find duplicates present in the current worksheet.
    What i am looking for will allow me to find duplicates present in diff worksheets of the excel workbook.

    Any suggestion?

    Thanks in advance,
    Troy.
      My Computer


  2. Posts : 3,009
    Windows 7 Home Premium 64bit
       #2

    Hi Troy :)

    Maybe something useful here:
    Highlight Duplicates, Macro? - ExcelBanter
      My Computer


  3. Posts : 1,794
    MS Windows 8
       #3

    you may also want to read this article about excel duplicate finder by Bill Hermanson.
    we have been using this trick for quiet some time.

    "Read more"

    Excel: Excel duplicate finder, conditional formatting, column headings
    Last edited by rbeldua; 28 Apr 2011 at 20:00.
      My Computer


  4. Posts : 64
    Windows 7
    Thread Starter
       #4

    thanks for the pointers guys.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 23:40.
Find Us