Hi All,

Is there any way to count duplicate values in a range.

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.

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.