Quote:
Originally Posted by joeu2004[_2_]
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.
|
Hi Thanks for the reply.
Yes you're right it was a typo. However this has not fully solved my problem. I'm finding it hard to explain, but i will give it a go: I need to count the number of unique A values against each unique B value. i.e. if there is duplication of A's against B's, this will show up as 1.
See extended example provided.
I really appreciate your help.
Thanks