Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Need software to find duplicates in excel worksheets

28 Apr 2011   #1

Windows 7
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,

My System SpecsSystem Spec
28 Apr 2011   #2

Windows 7 Home Premium 64bit

Hi Troy

Maybe something useful here:
Highlight Duplicates, Macro? - ExcelBanter
My System SpecsSystem Spec
28 Apr 2011   #3

MS Windows 8

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
My System SpecsSystem Spec

28 Apr 2011   #4

Windows 7

thanks for the pointers guys.
My System SpecsSystem Spec

 Need software to find duplicates in excel worksheets

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar help and support threads
Thread Forum
Find duplicates in Access 2013
Hi all, At the office we have a data base of about 12000 customers. actually it is 12000 orders. some customer purchased from us several times. We want to send our customers a letter and introduce a new item that they may want. the actual number of customers is about 8000 and it would cost...
Microsoft Office
Excel 2010, find & replace
Hi guys, In my Excel 2010 workbook there is a cell with the value of "90" in type of number/general. When I go to find and replace dialog box and try to find the number "90" by typing it in Find what rectangle, then I want the program looks for it in formulas (look in: Formulas). But it shows...
Microsoft Office
best soft to find pass for Excel 2010 files ??
best soft to find pass for Excel 2010 files ?? my Uncle create very important programs on Excel 2010 which tooks over 1-2 months to create but now they forgot its password I want to break its pass to help them
Microsoft Office
Word Document find and replace, find duplicates
I have a document that is hundreds of pages long. Within this document there are certain sentences, phrases that repeat and I need to find them in a practical manner. Now I could go through manually, look for lines I suspect are repeated elsewhere and search for them, but that would take...
Microsoft Office
Find two or more words in Excel?
I have Office 10 and I go to "find" in my excel spreadsheet and I would like to find "shot", "hospital"". "doctor" without doing 3 searches. So can I imput those 3 words and do a search and it will show me each word as they come up?
Microsoft Office
If statements in Excel worksheets.
How do you add if statements to formula in Excel that change the formating of the cells. For instace: If I have a sum which subtracts one cell from another and I want the colour of the text in the results cell to turn red if the value becomes negative. And: If I have a number in a...
Microsoft Office

Our Sites

Site Links

About Us

Find 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 22:32.

Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App