Need software to find duplicates in excel worksheets

[onlytanmoy]

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.

 

[Irene]

Hi Troy

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

 

[rbeldua]

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

 

[onlytanmoy]

thanks for the pointers guys.