Hi
I would use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
Hi!
I need to create a formula that will count unique
(duplicating/repeating)values. I have numeric data in one
column and text data in another.I want to create a
formula that will look at a value in column b that will
correspond with a value in column a, then give a count on
the duplicate/repeating value. I was going to use a
sumproduct formula, but there are over 3700 unique
values. Here is an example of my data.
Looking at the data below column b at Jdoe, and count how
many time 123 appeared next to Jdoe in column A, then
return the result in C1.
The formula I was going to use =sumproduct((A1:A12000=123)
*(B1:B12000="jdoe")). This would have to be created over
3700 times to get the correct result. This needs to be
created for all names in column B, which could correspond
to several different values in column a. There has to be
a quicker way.
Column A Column B Column C
A1:A12000 B1:B12000
123 Jdoe 2
456 Rsmith
789 Bmiller
987 Jdoe
654 Sjones
321 Bmiller
123 Jdoe
789 mbutler

Thanks T