Count multiple entries in a list

[steven H]

I have a 15000 list of tel numbers in column a, with corresponding email addresses in the column b, there are duplicate e-mail addresses in the column.

I want to identify ie count the multiple e-mail addresses, there are too many to pivot, any ideas?
This message was edited by steven H on 2002-10-03 06:02

 

[nehpets12]

Try using countif
=COUNTIF(B1:B1500,B1)

then you can sort this column ans see all duplicate entries

 

[steven H]

cheers that works fine, however I would like to summarise the count of multiples against a single instance, in much the same way as a pivot.

 

[Jim North]

check out SUMIF