Find duplicates in entire workbook

  • Thread starter Thread starter Mukesh
  • Start date Start date
Dear Mukesh

Duplicates can be cell duplicates, row duplicates. If you are looking at
values within a cell from find window (Ctrl+F) > 'Find All' will display all
the instances of a the search string.

If this post helps click Yes
 
Mukesh, Suppose you want to find the number of instances of a text say
"Mukesh" across columns A:B in the entire workbooks with Sheet names 'Sheet1'
'sheet2' and 'Sheet3', try the below

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet" & ROW(INDIRECT("1:3"))&"!A:B"),"mukesh"))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates Deletion ? 2
how to find duplicate entry in one sheet and in workbook 1
=PROPER() 2
I can only delete an entire row not a cell in excel 2013? 1
Excel Protection 2
Copy cell at a given time, is it possible? 2
Color Banding / Conditional Formatting 3
Entire Row Duplicates 6

Back
Top