Numerical values count

[imran ashraf]

Hi,
please i need to be count numerical values less than 3 and greater than 3 on base of locations. if find duplicate location in the rang that should be equal to zero or empty. Example . Italy have 3 numerical value (9,2,4) hare is one less than 3 and 2 more than 3 and other duplicate Italy is zero.


[TABLE="width: 317"]
<tbody>[TR]
[TD]A[/TD]
[TD] B [/TD]
[TD="align: left"]count less than 3 numerical value[/TD]
[TD="align: left"]count greater than 3 numerical value[/TD]
[/TR]
[TR]
[TD="align: left"]italy[/TD]
[TD="align: right"]9[/TD]
[TD="align: left"] 1[/TD]
[TD="align: left"] 2[/TD]
[/TR]
[TR]
[TD="align: left"]italy[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"] 0[/TD]
[TD] 0[/TD]
[/TR]
[TR]
[TD="align: left"]france[/TD]
[TD="align: right"]7[/TD]
[TD] 1[/TD]
[TD] 1[/TD]
[/TR]
[TR]
[TD="align: left"]italy[/TD]
[TD="align: right"]4[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[/TR]
[TR]
[TD="align: left"]france[/TD]
[TD="align: right"]2[/TD]
[TD] 0[/TD]
[TD] 0[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

This appears to be a duplicate of your previous question. Please do not post duplicates.

Thread closed.