From Find windowOptions select within 'Workbook' and specify the match type
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Mukesh" wrote:

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

Thanks.
Mukesh