PS.... I wrote:
"VZBoon" wrote:
I am looking for the formula to insert into
column E to provide the values in red.
[....]
http://www.excelbanter.com/attachment.php?attachmentid=470|

Put the following formula into E1 and copy down:

=COUNTIF($B$1:$B$6,D1)

I mean to say: assuming the value in E4 is a typo, and it should be 1.

If it is not a typo, you will need to explain why E4 is 2. It might have
something to do with 55 in both A5 (next to "C" in B5) and A6 (next to "D"
in B6). But in that case, the counting rule for column E is unclear. There
are many possible interpretations of the limited example.