Hi Vijay,

You can use Pivot Table to know about the duplicates. What you have to do,
just selection the data range, create pivot table with data in the row area
and count of data in the data field.

It will show you the number of times a data item is appearing in the
selected range. Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"VIJAY BHARDWAJ" wrote:

PLZ TELL ME ABOUT THE NO OF DUPLICATE IN SELECTION