Mark "1", Range of ±0.00001 & custom ±0.0000x value

[ibmy]

Hi,

decimal 6.21.xlsb
	A	B	C	D	E
1		± 0.00001	explaination :	± Custom (in this case ± 0.00005)	explaination :
2	1.22122		Valid Numbers : 1.22121 , 1.22122 , 1.22123		Valid Numbers : 1.22117 , 1.22118 , 1.22119 , 1.22120 , 1.22121 , 1.22122 , 1.22123 , 1.22124 , 1.22125 , 1.22126 , 1.22127
3	1.22127		RESET. New Valid Numbers : 1.22126 , 1.22127, 1.22128	1
4	1.22127	1		1
5	1.22126	1		1
6	1.22127	1		1
7	1.22128	1			Reset . New Valid Numbers : 1.22123 , 1.22124 , 1.22125 , 1.22126 , 1.22127 , 1.22128 , 1.22129 , 1.22130 , 1.22131 , 1.22132 , 1.22133
8	1.22126	1		1
9	1.22130		RESET. New Valid Numbers : 1.22129 , 1.22130, 1.22131	1
10	1.22129	1		1
11	1.22115		RESET. New Valid Numbers : 1.22114 , 1.22115, 1.22116		Reset . New Valid Numbers : 1.22110 , 1.22111 , 1.22112 , 1.22113 , 1.221214 , 1.22115 , 1.22116 , 1.22117 , 1.22118 , 1.22119 , 1.22120
12	1.22116	1		1
13	1.22116	1		1
14	1.22126		RESET. New Valid Numbers : 1.22125 , 1.22126, 1.22127		Reset . New Valid Numbers : 1.22121 , 1.22122 , 1.22123 , 1.22124 , 1.22125 , 1.22126 , 1.22127 , 1.22128 , 1.22129 , 1.22130 , 1.22131
15	1.22125	1		1
16	1.22127	1		1
17	1.22126	1		1
18	1.22121		RESET. New Valid Numbers : 1.22120 , 1.22121, 1.22122	1
19	1.22131		RESET. New Valid Numbers : 1.22130 , 1.22131, 1.22132	1
(2) ~ (4)

Expected results are in Column B & Column D.
Column C & Column E just explaination of how results in Column B & Column D are produced.

Column D is where custom ±0.0000x value I wanted test. I hope the formula/code provided able to change value ±0.0000x.

Sample of 250-300k row data.

Thanks reading my thread.

 

[fjns]

Hi, see the linked file (with 6 auxiliary columns) for a possible solution...

The formulas used in the table:
B2: =IF(A2="","",IF(G2=1,"",1))
D2: =IF(A2="","",IF(I2=1,"",1))
F2: =IF(A2="","",IF(K2=1,"",1))
G2: =IF(A2="","",1)
G3: =IF(A3="","",IF(AND(A3>=H2-0,00001,A3<=H2+0,00001),0,1))
H2: =IF(A2="","",IF(G2=1,A2,H1))
I2: =IF(A2="","",1)
I3: =IF(A3="","",IF(AND(A3>=J2-0,00005,A3<=J2+0,00005),0,1))
J2: =IF(A2="","",IF(I2=1,A2,J1))
K2: =IF(A2="","",1)
K3: =IF(A3="","",IF(AND(A3>=L2-A$1,A3<=L2+A$1),0,1))
L2: =IF(A2="","",IF(K2=1,A2,L1))

621.xlsx