Assuming your list begins at A2 type the following and copy it down
=IF(AND(COUNTIF(A:A,A2)1,SUMIF($A$1:A1,A2,$B$1:B1 )1),"",COUNTIF(A:A,A2))

"bjg" wrote in message
...

HI, I applied =IF(A1=A2;COUNTIF(A:A;A1);"") (NOTE: semcolon rather than
comma initally suggested), and it ends up with the following outcome,

1
2
3 3
3 3
3
4 2
4
5 2
5
6

which is not correct. A correct answer should be
1 1
2 1
3 3
3
3
4 2
4
5 2
5
6 1

Any comments are welcome!


--
bjg
------------------------------------------------------------------------
bjg's Profile:
http://www.excelforum.com/member.php...o&userid=16776
View this thread: http://www.excelforum.com/showthread...hreadid=319730