Hi Jacob,

I am using =COUNTIF() and I get result as 1, 2 - is it possible to count
from entire workbook so I know the number of times it has been duplicated.

Thanks.
Mukesh




"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