Checking for multiple entries in a column

[shaero]

Hello Forum,

I have multiple entries in a column and I'm trying to check if there are any duplicates. For example,

Column A
4132
5321
4132
8421
1341
5321
4132

What I want for this formula to do is to check the column and see if any of the cells repeat, and if they do determine the multiplicity. So the final result would look like:
A B
4132 3
5321 2
4132 3
8421 1
1341 1
5321 2

Any ideas?

Thanks in advance,

shaero

 

[jim may]

Excel Workbook
	A	B
1	4132	3
2	5321	2
3	4132	3
4	8421	1
5	1341	1
6	5321	2
7	4132	3
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B1	=COUNTIF(A:A,A1)
B2	=COUNTIF(A:A,A2)
B3	=COUNTIF(A:A,A3)
B4	=COUNTIF(A:A,A4)
B5	=COUNTIF(A:A,A5)
B6	=COUNTIF(A:A,A6)
B7	=COUNTIF(A:A,A7)

 

[Foo_Man_Chu]

use the countif function. Example:

=COUNTIF($A:$A,A1)

paste that formula next to the first cell and copy it down, assuming that the first cell is A1

HTH

 

[shaero]

thank you!