SELECT DUPLICATE IN SELECTION

[VIJAY BHARDWAJ]

PLZ TELL ME ABOUT THE NO OF DUPLICATE IN SELECTION

 

[PJ]

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

 

[DILipandey]

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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India