SELECT DUPLICATE IN SELECTION
 

PLZ TELL ME ABOUT THE NO OF DUPLICATE IN SELECTION

SELECT DUPLICATE IN SELECTION
 

Vijay

Chip Pearson has various techniques for dealing with duplicates on his site.
I suggest you check out:
http://www.cpearson.com/excel/Duplicates.aspx

"VIJAY BHARDWAJ" wrote:

PLZ TELL ME ABOUT THE NO OF DUPLICATE IN SELECTION

SELECT DUPLICATE IN SELECTION
 

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