Find duplicates in entire workbook

M

Mukesh

Is it possible to find duplicates in entire workbook?
Please advise.

Thanks.
Mukesh
 
J

Jacob Skaria

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
 
J

Jacob Skaria

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
 
Top