Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SELECT DUPLICATE IN SELECTION
PLZ TELL ME ABOUT THE NO OF DUPLICATE IN SELECTION
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select entire row and column in a sigle cell selection | Excel Worksheet Functions | |||
Select last cell in Selection | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
how to select fewer cells without canceling original selection | Excel Discussion (Misc queries) | |||
I do not see the selection colour when I select some cells | Excel Discussion (Misc queries) |