Distinguish whether the next number down is <20 (but not including the current number)

[tlacloche]

Hello,

In column A i have employee ID numbers.
In column B, I have an event list.

I would like column C to detect when...
...the word "Transfer" is mentioned in column B...
...whilst beside it in column A the number is less than 20...and...
...the next 2 numbers down are also less than 20, BUT at least one of those numbers are different to the initial number.

So for example:
4 Transfer [POSITIVE RESULT]
4 Apple
7 Banana


BUT
4 Transfer
4 Apple
4 Banana
Will have No Result

I would like the word used to be "Positive Result" please.

Thank you

[ragulduy]

In C1:
If(and(B1="Transfer",A1<20,countif(A1:A3,"="&A3)<3),"Positive Result","No Result")

[Melvinrobb]

=IF(AND(B2="Transfer",COUNTIF(A3:A4,A2)<2,COUNTIF(A2:A4,"<20")=3),"Positive Result","")

[tlacloche]

you almost got it yudlugar...
its still giving a positive result when one of the numbers down is the same number and the other is over 20.

for example:
10 Transfer
10 Apple
28 Banana
should not give a positive result, because there is a number above 20.

Remember, if both numbers down are less than 20 and at least one of them is not the same as the transfer number, then its positive.
Both numbers down HAVE to be less than 20

i hope ive explained that well.
thank you for your assistance

[tlacloche]

You got it melvinrobb. Thank you!!!