Count Duplicate Values
Hi All,
Is there any way to count duplicate values in a range. |
Count Duplicate Values
It is very to use a Pivot Table to do this. The Pivot Table can be made to
list each unique item in the list and next to the number of times the item appears. See: http://peltiertech.com/Excel/Pivots/pivotstart.htm -- Gary''s Student - gsnu200771 "Abdul Shakeel" wrote: Hi All, Is there any way to count duplicate values in a range. |
Count Duplicate Values
You can use countif function
Easy example, put all unique entries in the range in a column, use countif,a dn ask to count the original range where the entry is similar to the unique entry,this should give you the no of unique entries, if trying for multiple columns use the same logic with concatenate function. if cells are A1 tom A2 harry A3 tom A4 harry A5 fred A6 tom A7 harry A8 fred A9 gary Enter in B1 tom C1 =COUNTIF(A1:A9,B1) Regards TT "Gary''s Student" wrote: It is very to use a Pivot Table to do this. The Pivot Table can be made to list each unique item in the list and next to the number of times the item appears. See: http://peltiertech.com/Excel/Pivots/pivotstart.htm -- Gary''s Student - gsnu200771 "Abdul Shakeel" wrote: Hi All, Is there any way to count duplicate values in a range. |
All times are GMT +1. The time now is 01:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com