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.

A	B	count less than 3 numerical value	count greater than 3 numerical value
italy	9	1	2
italy	2	0	0
france	7	1	1
italy	4	0	0
france	2	0	0

<tbody>
</tbody>

 

[RoryA]

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

Thread closed.