Finding the position of the first values, to fall between a % range

Hi everyone,

I'm looking to find the first time a series of values (for their given ID, A:A), fall between the % value in KS2.

1% =1% > x > -1%
2% = 2% > x > -2%

An example of a solution:

54H7Zj3VRmGQ6fmjdqlFng.png

For the given IDs, 150 is the first time all the values fall between -1% & 1% (further correct examples (as far as I'm aware ), KS3:KS22)

I'm just not entirely sure how to create a formula to calc those figures; the tricky bit - looking simultaneously at 4 rows

Hope that wasn't too confusing; any questions pop em below

ty

Mdn

Please try at KS3 press Ctrl+Shift+Enter and copy down

=INDEX($C$2:$KQ$2,MATCH(COUNTIF($A$3:$A$22,A3),MMULT(TRANSPOSE(--($A$3:$A$22=A3)),--(ABS($C$3:$KQ$22)<=$KS$2)),))