Extract values from a defined range from a packaging machine

[fogarasia]

Hi All!
I am struggling with tons of data. I have a packaging machine and the raw statistical data from it. I want to list the data from a desired packaging weight defined in column B. The data is In column D. After having this data I can manipulate statistical analysis.
So I want to have collected all weight data from Column D for TargetWeight 700. After a while the DatiSTatistica_TargetWeight value in column D changes for ex. to 2500, then I am not interested in these values. So I want to make statistics for a desired TargetWeights.

ANd if you see, there are other values too in column B, which ere not interesting to me.

Feb02_statisztika.xlsx
	B	C	D
1	VarName	TimeString	VarValue
2	DatiStatistica_ProgNumber	27/01/2023 01:21	1
3	DatiStatistica_TargetWeight	27/01/2023 01:21	700
4	Recipes_Recipe{0}_TollMinus	27/01/2023 01:21	30
5	Recipes_Recipe{0}_TollPlus	27/01/2023 01:21	100
6	$RT_DIS$	27/01/2023 01:21	0
7	DatiStatistica_ProgNumber	27/01/2023 01:21	1
8	DatiStatistica_TargetWeight	27/01/2023 01:21	700
9	Recipes_Recipe{0}_TollMinus	27/01/2023 01:21	30
10	Recipes_Recipe{0}_TollPlus	27/01/2023 01:21	100
11	$RT_DIS$	27/01/2023 01:21	0
12	DatiStatistica_ProgNumber	27/01/2023 01:22	1
13	DatiStatistica_TargetWeight	27/01/2023 01:22	700
14	Recipes_Recipe{0}_TollMinus	27/01/2023 01:22	30
15	Recipes_Recipe{0}_TollPlus	27/01/2023 01:22	100
16	DatiStatistica_ProgNumber	30/01/2023 08:36	1
17	DatiStatistica_TargetWeight	30/01/2023 08:36	700
18	Recipes_Recipe{0}_TollMinus	30/01/2023 08:36	30
19	Recipes_Recipe{0}_TollPlus	30/01/2023 08:36	100
20	DatiStatistica_ProgNumber	30/01/2023 09:16	1
21	DatiStatistica_TargetWeight	30/01/2023 09:16	700
22	Recipes_Recipe{0}_TollMinus	30/01/2023 09:16	30
23	Recipes_Recipe{0}_TollPlus	30/01/2023 09:16	100
24	DatiStatistica_CombiWeight	30/01/2023 09:17	0
25	DatiStatistica_CombiWeight	30/01/2023 09:17	0
26	DatiStatistica_CombiWeight	30/01/2023 09:17	0
27	DatiStatistica_CombiWeight	30/01/2023 09:17	0
28	DatiStatistica_CombiWeight	30/01/2023 09:17	0
29	DatiStatistica_CombiWeight	30/01/2023 09:17	700
30	DatiStatistica_CombiWeight	30/01/2023 09:17	700
31	DatiStatistica_CombiWeight	30/01/2023 09:17	703
32	DatiStatistica_CombiWeight	30/01/2023 09:17	699
33	DatiStatistica_CombiWeight	30/01/2023 09:17	700
34	DatiStatistica_CombiWeight	30/01/2023 09:17	700
35	DatiStatistica_CombiWeight	30/01/2023 09:17	699
36	DatiStatistica_CombiWeight	30/01/2023 09:17	700
37	DatiStatistica_CombiWeight	30/01/2023 09:17	697
38	DatiStatistica_CombiWeight	30/01/2023 09:17	701
39	DatiStatistica_CombiWeight	30/01/2023 09:17	700
40	DatiStatistica_CombiWeight	30/01/2023 09:17	699
41	DatiStatistica_CombiWeight	30/01/2023 09:17	700
42	DatiStatistica_CombiWeight	30/01/2023 09:17	700
43	DatiStatistica_CombiWeight	30/01/2023 09:18	700
44	DatiStatistica_CombiWeight	30/01/2023 09:18	700
45	DatiStatistica_CombiWeight	30/01/2023 09:18	699
46	DatiStatistica_CombiWeight	30/01/2023 09:18	700
47	DatiStatistica_CombiWeight	30/01/2023 09:18	696
48	DatiStatistica_CombiWeight	30/01/2023 09:18	698
49	DatiStatistica_CombiWeight	30/01/2023 09:18	700
50	DatiStatistica_CombiWeight	30/01/2023 09:18	699
51	DatiStatistica_CombiWeight	30/01/2023 09:18	700
52	DatiStatistica_CombiWeight	30/01/2023 09:18	697
53	DatiStatistica_CombiWeight	30/01/2023 09:18	700
54	DatiStatistica_CombiWeight	30/01/2023 09:18	700
55	DatiStatistica_CombiWeight	30/01/2023 09:18	699
56	DatiStatistica_CombiWeight	30/01/2023 09:18	700
57	DatiStatistica_CombiWeight	30/01/2023 09:18	698
58	DatiStatistica_CombiWeight	30/01/2023 09:18	700
59	DatiStatistica_CombiWeight	30/01/2023 09:18	700
60	DatiStatistica_CombiWeight	30/01/2023 09:18	699
61	DatiStatistica_CombiWeight	30/01/2023 09:18	696
62	DatiStatistica_CombiWeight	30/01/2023 09:18	707
63	DatiStatistica_CombiWeight	30/01/2023 09:18	700
64	DatiStatistica_CombiWeight	30/01/2023 09:18	700
65	DatiStatistica_CombiWeight	30/01/2023 09:18	700
66	DatiStatistica_CombiWeight	30/01/2023 09:18	700
67	DatiStatistica_CombiWeight	30/01/2023 09:18	698
68	DatiStatistica_CombiWeight	30/01/2023 09:18	699
69	DatiStatistica_CombiWeight	30/01/2023 09:18	701
70	DatiStatistica_CombiWeight	30/01/2023 09:18	701
71	DatiStatistica_CombiWeight	30/01/2023 09:18	700
72	DatiStatistica_CombiWeight	30/01/2023 09:18	700
73	DatiStatistica_CombiWeight	30/01/2023 09:18	700
74	DatiStatistica_CombiWeight	30/01/2023 09:18	700
75	DatiStatistica_CombiWeight	30/01/2023 09:18	701
76	DatiStatistica_CombiWeight	30/01/2023 09:18	703
77	DatiStatistica_CombiWeight	30/01/2023 09:19	700
78	DatiStatistica_CombiWeight	30/01/2023 09:19	700
79	DatiStatistica_CombiWeight	30/01/2023 09:19	699
feb02_bal

 

[fogarasia]

Hi All!
I am struggling with tons of data. I have a packaging machine and the raw statistical data from it. I want to list the data from a desired packaging weight defined in column B. The data is In column D. After having this data I can manipulate statistical analysis.
So I want to have collected all weight data from Column D for TargetWeight 700. After a while the DatiSTatistica_TargetWeight value in column D changes for ex. to 2500, then I am not interested in these values. So I want to make statistics for a desired TargetWeights.

ANd if you see, there are other values too in column B, which ere not interesting to me.

Feb02_statisztika.xlsx
	B	C	D
1	VarName	TimeString	VarValue
2	DatiStatistica_ProgNumber	27/01/2023 01:21	1
3	DatiStatistica_TargetWeight	27/01/2023 01:21	700
4	Recipes_Recipe{0}_TollMinus	27/01/2023 01:21	30
5	Recipes_Recipe{0}_TollPlus	27/01/2023 01:21	100
6	$RT_DIS$	27/01/2023 01:21	0
7	DatiStatistica_ProgNumber	27/01/2023 01:21	1
8	DatiStatistica_TargetWeight	27/01/2023 01:21	700
9	Recipes_Recipe{0}_TollMinus	27/01/2023 01:21	30
10	Recipes_Recipe{0}_TollPlus	27/01/2023 01:21	100
11	$RT_DIS$	27/01/2023 01:21	0
12	DatiStatistica_ProgNumber	27/01/2023 01:22	1
13	DatiStatistica_TargetWeight	27/01/2023 01:22	700
14	Recipes_Recipe{0}_TollMinus	27/01/2023 01:22	30
15	Recipes_Recipe{0}_TollPlus	27/01/2023 01:22	100
16	DatiStatistica_ProgNumber	30/01/2023 08:36	1
17	DatiStatistica_TargetWeight	30/01/2023 08:36	700
18	Recipes_Recipe{0}_TollMinus	30/01/2023 08:36	30
19	Recipes_Recipe{0}_TollPlus	30/01/2023 08:36	100
20	DatiStatistica_ProgNumber	30/01/2023 09:16	1
21	DatiStatistica_TargetWeight	30/01/2023 09:16	700
22	Recipes_Recipe{0}_TollMinus	30/01/2023 09:16	30
23	Recipes_Recipe{0}_TollPlus	30/01/2023 09:16	100
24	DatiStatistica_CombiWeight	30/01/2023 09:17	0
25	DatiStatistica_CombiWeight	30/01/2023 09:17	0
26	DatiStatistica_CombiWeight	30/01/2023 09:17	0
27	DatiStatistica_CombiWeight	30/01/2023 09:17	0
28	DatiStatistica_CombiWeight	30/01/2023 09:17	0
29	DatiStatistica_CombiWeight	30/01/2023 09:17	700
30	DatiStatistica_CombiWeight	30/01/2023 09:17	700
31	DatiStatistica_CombiWeight	30/01/2023 09:17	703
32	DatiStatistica_CombiWeight	30/01/2023 09:17	699
33	DatiStatistica_CombiWeight	30/01/2023 09:17	700
34	DatiStatistica_CombiWeight	30/01/2023 09:17	700
35	DatiStatistica_CombiWeight	30/01/2023 09:17	699
36	DatiStatistica_CombiWeight	30/01/2023 09:17	700
37	DatiStatistica_CombiWeight	30/01/2023 09:17	697
38	DatiStatistica_CombiWeight	30/01/2023 09:17	701
39	DatiStatistica_CombiWeight	30/01/2023 09:17	700
40	DatiStatistica_CombiWeight	30/01/2023 09:17	699
41	DatiStatistica_CombiWeight	30/01/2023 09:17	700
42	DatiStatistica_CombiWeight	30/01/2023 09:17	700
43	DatiStatistica_CombiWeight	30/01/2023 09:18	700
44	DatiStatistica_CombiWeight	30/01/2023 09:18	700
45	DatiStatistica_CombiWeight	30/01/2023 09:18	699
46	DatiStatistica_CombiWeight	30/01/2023 09:18	700
47	DatiStatistica_CombiWeight	30/01/2023 09:18	696
48	DatiStatistica_CombiWeight	30/01/2023 09:18	698
49	DatiStatistica_CombiWeight	30/01/2023 09:18	700
50	DatiStatistica_CombiWeight	30/01/2023 09:18	699
51	DatiStatistica_CombiWeight	30/01/2023 09:18	700
52	DatiStatistica_CombiWeight	30/01/2023 09:18	697
53	DatiStatistica_CombiWeight	30/01/2023 09:18	700
54	DatiStatistica_CombiWeight	30/01/2023 09:18	700
55	DatiStatistica_CombiWeight	30/01/2023 09:18	699
56	DatiStatistica_CombiWeight	30/01/2023 09:18	700
57	DatiStatistica_CombiWeight	30/01/2023 09:18	698
58	DatiStatistica_CombiWeight	30/01/2023 09:18	700
59	DatiStatistica_CombiWeight	30/01/2023 09:18	700
60	DatiStatistica_CombiWeight	30/01/2023 09:18	699
61	DatiStatistica_CombiWeight	30/01/2023 09:18	696
62	DatiStatistica_CombiWeight	30/01/2023 09:18	707
63	DatiStatistica_CombiWeight	30/01/2023 09:18	700
64	DatiStatistica_CombiWeight	30/01/2023 09:18	700
65	DatiStatistica_CombiWeight	30/01/2023 09:18	700
66	DatiStatistica_CombiWeight	30/01/2023 09:18	700
67	DatiStatistica_CombiWeight	30/01/2023 09:18	698
68	DatiStatistica_CombiWeight	30/01/2023 09:18	699
69	DatiStatistica_CombiWeight	30/01/2023 09:18	701
70	DatiStatistica_CombiWeight	30/01/2023 09:18	701
71	DatiStatistica_CombiWeight	30/01/2023 09:18	700
72	DatiStatistica_CombiWeight	30/01/2023 09:18	700
73	DatiStatistica_CombiWeight	30/01/2023 09:18	700
74	DatiStatistica_CombiWeight	30/01/2023 09:18	700
75	DatiStatistica_CombiWeight	30/01/2023 09:18	701
76	DatiStatistica_CombiWeight	30/01/2023 09:18	703
77	DatiStatistica_CombiWeight	30/01/2023 09:19	700
78	DatiStatistica_CombiWeight	30/01/2023 09:19	700
79	DatiStatistica_CombiWeight	30/01/2023 09:19	699
feb02_bal

So if TargetWeight reaches my criteria (for example 700 in column D) then list values until TargetWeight is not different than my target value. It can happen, that we run TargetWeight 700 for a time, then change to 2500 and back to 700 again. In this case, I need all the values around 700. The harder part is, that TargetWeight can be 500 and 600, and 700 too, so is not a solution to sort between two numbers, as 680 can be from TargetWeight 700 and TargetWeight 600 too because of deviation.

 

[Georgiboy]

If i have understood then you may be able to use the filter formula:

Book1
	A	B	C	D	E	F	G	H	I	J
1	VarName	TimeString	VarValue			VarName	TimeString	VarValue		Target weight
2	DatiStatistica_ProgNumber	44953.0563	1			DatiStatistica_TargetWeight	44953.06	700		700
3	DatiStatistica_TargetWeight	44953.0563	700			DatiStatistica_TargetWeight	44953.06	700
4	Recipes_Recipe{0}_TollMinus	44953.0563	30			DatiStatistica_TargetWeight	44953.06	700
5	Recipes_Recipe{0}_TollPlus	44953.0563	100			DatiStatistica_TargetWeight	44956.36	700
6	$RT_DIS$	44953.0563	0			DatiStatistica_TargetWeight	44956.39	700
7	DatiStatistica_ProgNumber	44953.0569	1
8	DatiStatistica_TargetWeight	44953.0569	700
9	Recipes_Recipe{0}_TollMinus	44953.0569	30
10	Recipes_Recipe{0}_TollPlus	44953.0569	100
11	$RT_DIS$	44953.0569	0
12	DatiStatistica_ProgNumber	44953.057	1
13	DatiStatistica_TargetWeight	44953.057	700
14	Recipes_Recipe{0}_TollMinus	44953.057	30
15	Recipes_Recipe{0}_TollPlus	44953.057	100
16	DatiStatistica_ProgNumber	44956.3589	1
17	DatiStatistica_TargetWeight	44956.3589	700
18	Recipes_Recipe{0}_TollMinus	44956.3589	30
19	Recipes_Recipe{0}_TollPlus	44956.3589	100
20	DatiStatistica_ProgNumber	44956.3867	1
21	DatiStatistica_TargetWeight	44956.3867	700
22	Recipes_Recipe{0}_TollMinus	44956.3867	30
23	Recipes_Recipe{0}_TollPlus	44956.3867	100
24	DatiStatistica_CombiWeight	44956.3869	0
25	DatiStatistica_CombiWeight	44956.3869	0
26	DatiStatistica_CombiWeight	44956.3869	0
27	DatiStatistica_CombiWeight	44956.3869	0
28	DatiStatistica_CombiWeight	44956.387	0
29	DatiStatistica_CombiWeight	44956.3871	700
30	DatiStatistica_CombiWeight	44956.3872	700
31	DatiStatistica_CombiWeight	44956.3872	703
32	DatiStatistica_CombiWeight	44956.3872	699
33	DatiStatistica_CombiWeight	44956.3872	700
34	DatiStatistica_CombiWeight	44956.3872	700
35	DatiStatistica_CombiWeight	44956.3873	699
36	DatiStatistica_CombiWeight	44956.3874	700
37	DatiStatistica_CombiWeight	44956.3874	697
38	DatiStatistica_CombiWeight	44956.3874	701
39	DatiStatistica_CombiWeight	44956.3874	700
40	DatiStatistica_CombiWeight	44956.3874	699
41	DatiStatistica_CombiWeight	44956.3874	700
42	DatiStatistica_CombiWeight	44956.3875	700
43	DatiStatistica_CombiWeight	44956.3875	700
44	DatiStatistica_CombiWeight	44956.3875	700
45	DatiStatistica_CombiWeight	44956.3875	699
46	DatiStatistica_CombiWeight	44956.3876	700
47	DatiStatistica_CombiWeight	44956.3876	696
48	DatiStatistica_CombiWeight	44956.3876	698
49	DatiStatistica_CombiWeight	44956.3876	700
50	DatiStatistica_CombiWeight	44956.3876	699
51	DatiStatistica_CombiWeight	44956.3877	700
52	DatiStatistica_CombiWeight	44956.3877	697
53	DatiStatistica_CombiWeight	44956.3877	700
54	DatiStatistica_CombiWeight	44956.3877	700
55	DatiStatistica_CombiWeight	44956.3877	699
56	DatiStatistica_CombiWeight	44956.3877	700
57	DatiStatistica_CombiWeight	44956.3878	698
58	DatiStatistica_CombiWeight	44956.3878	700
59	DatiStatistica_CombiWeight	44956.3879	700
60	DatiStatistica_CombiWeight	44956.3879	699
61	DatiStatistica_CombiWeight	44956.3879	696
62	DatiStatistica_CombiWeight	44956.3879	707
63	DatiStatistica_CombiWeight	44956.3879	700
64	DatiStatistica_CombiWeight	44956.3879	700
65	DatiStatistica_CombiWeight	44956.388	700
66	DatiStatistica_CombiWeight	44956.388	700
67	DatiStatistica_CombiWeight	44956.388	698
68	DatiStatistica_CombiWeight	44956.388	699
69	DatiStatistica_CombiWeight	44956.388	701
70	DatiStatistica_CombiWeight	44956.388	701
71	DatiStatistica_CombiWeight	44956.3881	700
72	DatiStatistica_CombiWeight	44956.3881	700
73	DatiStatistica_CombiWeight	44956.3881	700
74	DatiStatistica_CombiWeight	44956.3882	700
75	DatiStatistica_CombiWeight	44956.3882	701
76	DatiStatistica_CombiWeight	44956.3882	703
77	DatiStatistica_CombiWeight	44956.3882	700
78	DatiStatistica_CombiWeight	44956.3882	700
79	DatiStatistica_CombiWeight	44956.3882	699
Sheet1

Cell Formulas
Range	Formula
F2:H6	F2	=FILTER(A2:C79,(A2:A79 ="DatiStatistica_TargetWeight")*(C2:C79=$J$2),"")
Dynamic array formulas.

 

[fogarasia]

Not really. Just to understand the list: I set to the packaging machine that I want to package 700 ml (this is Target Weight - A column), then when the machine starts to package I will have Combi Weight in column A with a value in column C, which value is Standard Deviated from the Target Weight. And I want to list all the values which are after setting Target Weight (as in column A I will have a New target Weight when I set a different one, or I restart the machine). If you see, for Target Weight 700 I have Combi Weight 700, 699, 703, etc. And I want to list all these Combi Weight values from column C. And for listing, I want to set a Target Weight for what to look the formula, because I can have a few hundred thousand Combi Weight values.

 

[Fluff]

Can you post what your expected results are from that data.

 

[fogarasia]

It Should be something like this, but for example here I don't need the values from 2500.

Feb02_statisztika.xlsx
	K	L	M
1641	DatiStatistica_CombiWeight	30/01/2023 10:01:56	700
1642	DatiStatistica_CombiWeight	30/01/2023 10:01:57	702
1643	DatiStatistica_CombiWeight	30/01/2023 10:01:58	706
1644	DatiStatistica_CombiWeight	30/01/2023 10:01:59	699
1645	DatiStatistica_CombiWeight	30/01/2023 10:02:01	701
1646	DatiStatistica_CombiWeight	30/01/2023 10:02:05	700
1647	DatiStatistica_CombiWeight	30/01/2023 10:02:08	700
1648	DatiStatistica_CombiWeight	30/01/2023 10:02:09	699
1649	DatiStatistica_CombiWeight	30/01/2023 10:02:10	700
1650	DatiStatistica_CombiWeight	30/01/2023 10:02:11	700
1651	DatiStatistica_CombiWeight	30/01/2023 10:02:13	697
1652	DatiStatistica_CombiWeight	30/01/2023 10:02:14	697
1653	DatiStatistica_CombiWeight	30/01/2023 10:02:15	698
1654	DatiStatistica_CombiWeight	30/01/2023 10:02:16	698
1655	DatiStatistica_CombiWeight	30/01/2023 10:02:17	704
1656	DatiStatistica_CombiWeight	30/01/2023 10:02:19	699
1657	DatiStatistica_CombiWeight	30/01/2023 10:02:20	697
1658	DatiStatistica_CombiWeight	30/01/2023 10:02:21	700
1659	DatiStatistica_CombiWeight	30/01/2023 10:02:25	697
1660	DatiStatistica_CombiWeight	30/01/2023 10:02:28	700
1661	DatiStatistica_CombiWeight	30/01/2023 10:02:29	700
1662	DatiStatistica_CombiWeight	31/01/2023 08:39:19	0
1663	DatiStatistica_CombiWeight	31/01/2023 08:39:20	0
1664	DatiStatistica_CombiWeight	31/01/2023 08:39:21	0
1665	DatiStatistica_CombiWeight	31/01/2023 08:39:22	0
1666	DatiStatistica_CombiWeight	31/01/2023 08:39:24	0
1667	DatiStatistica_CombiWeight	31/01/2023 08:39:29	2500
1668	DatiStatistica_CombiWeight	31/01/2023 08:39:30	2500
1669	DatiStatistica_CombiWeight	31/01/2023 08:39:32	2527
1670	DatiStatistica_CombiWeight	31/01/2023 08:39:34	2527
1671	DatiStatistica_CombiWeight	31/01/2023 08:39:36	2500
1672	DatiStatistica_CombiWeight	31/01/2023 08:39:38	2500
1673	DatiStatistica_CombiWeight	31/01/2023 08:39:40	2511
1674	DatiStatistica_CombiWeight	31/01/2023 08:39:42	2502
1675	DatiStatistica_CombiWeight	31/01/2023 08:39:44	2502
1676	DatiStatistica_CombiWeight	31/01/2023 08:39:48	2500
1677	DatiStatistica_CombiWeight	31/01/2023 08:39:50	2500
1678	DatiStatistica_CombiWeight	31/01/2023 08:39:52	2500
1679	DatiStatistica_CombiWeight	31/01/2023 08:39:54	2525
1680	DatiStatistica_CombiWeight	31/01/2023 08:39:56	2525
1681	DatiStatistica_CombiWeight	31/01/2023 08:39:58	2500
feb02_bal

 

[fogarasia]

I used the simple filter function until we started to package 500, 600, and 700 where things get complicated, as the deviation can mix the values. Until now when we had just a Target Weight value of 700, then I filtered for a range between 600 and 800 and it was ok, but when having 500, 600, and 700 things get complicated. And here comes that I need to use just that Combi Weight values which appears after a desired Target Weight.

 

[fogarasia]

So anybody any solution?

 

[Georgiboy]

Not sure i fully understand, is the below closer to what you need?

Book1
	A	B	C	D	E	F	G	H	I
1	VarName	TimeString	VarValue		VarName	TimeString	VarValue		Target weight
2	DatiStatistica_ProgNumber	27/01/2023 01:21:00	1		DatiStatistica_CombiWeight	30/01/2023 09:17:10	0		2500
3	DatiStatistica_TargetWeight	27/01/2023 01:21:00	700		DatiStatistica_CombiWeight	30/01/2023 09:17:11	0
4	Recipes_Recipe{0}_TollMinus	27/01/2023 01:21:00	30		DatiStatistica_CombiWeight	30/01/2023 09:17:11	0
5	Recipes_Recipe{0}_TollPlus	27/01/2023 01:21:00	100		DatiStatistica_CombiWeight	30/01/2023 09:17:12	0
6	$RT_DIS$	27/01/2023 01:21:02	0		DatiStatistica_CombiWeight	30/01/2023 09:17:13	0
7	DatiStatistica_ProgNumber	27/01/2023 01:21:52	1		DatiStatistica_CombiWeight	30/01/2023 09:17:29	700
8	DatiStatistica_TargetWeight	27/01/2023 01:21:52	700		DatiStatistica_CombiWeight	30/01/2023 09:17:32	700
9	Recipes_Recipe{0}_TollMinus	27/01/2023 01:21:52	30		DatiStatistica_CombiWeight	30/01/2023 09:17:33	703
10	Recipes_Recipe{0}_TollPlus	27/01/2023 01:21:52	100		DatiStatistica_CombiWeight	30/01/2023 09:17:34	699
11	$RT_DIS$	27/01/2023 01:21:53	0		DatiStatistica_CombiWeight	30/01/2023 09:17:35	700
12	DatiStatistica_ProgNumber	27/01/2023 01:22:02	1		DatiStatistica_CombiWeight	30/01/2023 09:17:35	700
13	DatiStatistica_TargetWeight	27/01/2023 01:22:02	700		DatiStatistica_CombiWeight	30/01/2023 09:17:45	699
14	Recipes_Recipe{0}_TollMinus	27/01/2023 01:22:02	30		DatiStatistica_CombiWeight	30/01/2023 09:17:48	700
15	Recipes_Recipe{0}_TollPlus	27/01/2023 01:22:02	100		DatiStatistica_CombiWeight	30/01/2023 09:17:49	697
16	DatiStatistica_ProgNumber	30/01/2023 08:36:46	1		DatiStatistica_CombiWeight	30/01/2023 09:17:50	701
17	DatiStatistica_TargetWeight	30/01/2023 08:36:46	700		DatiStatistica_CombiWeight	30/01/2023 09:17:51	700
18	Recipes_Recipe{0}_TollMinus	30/01/2023 08:36:46	30		DatiStatistica_CombiWeight	30/01/2023 09:17:52	699
19	Recipes_Recipe{0}_TollPlus	30/01/2023 08:36:46	100		DatiStatistica_CombiWeight	30/01/2023 09:17:53	700
20	DatiStatistica_ProgNumber	30/01/2023 09:16:48	1		DatiStatistica_CombiWeight	30/01/2023 09:17:59	700
21	DatiStatistica_TargetWeight	30/01/2023 09:16:48	700		DatiStatistica_CombiWeight	30/01/2023 09:18:02	700
22	Recipes_Recipe{0}_TollMinus	30/01/2023 09:16:48	30		DatiStatistica_CombiWeight	30/01/2023 09:18:03	700
23	Recipes_Recipe{0}_TollPlus	30/01/2023 09:16:48	100		DatiStatistica_CombiWeight	30/01/2023 09:18:04	699
24	DatiStatistica_CombiWeight	30/01/2023 09:17:10	0		DatiStatistica_CombiWeight	30/01/2023 09:18:05	700
25	DatiStatistica_CombiWeight	30/01/2023 09:17:11	0		DatiStatistica_CombiWeight	30/01/2023 09:18:06	696
26	DatiStatistica_CombiWeight	30/01/2023 09:17:11	0		DatiStatistica_CombiWeight	30/01/2023 09:18:07	698
27	DatiStatistica_CombiWeight	30/01/2023 09:17:12	0		DatiStatistica_CombiWeight	30/01/2023 09:18:07	700
28	DatiStatistica_CombiWeight	30/01/2023 09:17:13	0		DatiStatistica_CombiWeight	30/01/2023 09:18:12	699
29	DatiStatistica_CombiWeight	30/01/2023 09:17:29	700		DatiStatistica_CombiWeight	30/01/2023 09:18:16	700
30	DatiStatistica_CombiWeight	30/01/2023 09:17:32	700		DatiStatistica_CombiWeight	30/01/2023 09:18:17	697
31	DatiStatistica_CombiWeight	30/01/2023 09:17:33	703		DatiStatistica_CombiWeight	30/01/2023 09:18:18	700
32	DatiStatistica_CombiWeight	30/01/2023 09:17:34	699		DatiStatistica_CombiWeight	30/01/2023 09:18:19	700
33	DatiStatistica_CombiWeight	30/01/2023 09:17:35	700		DatiStatistica_CombiWeight	30/01/2023 09:18:19	699
34	DatiStatistica_CombiWeight	30/01/2023 09:17:35	700		DatiStatistica_CombiWeight	30/01/2023 09:18:20	700
35	DatiStatistica_CombiWeight	30/01/2023 09:17:45	699		DatiStatistica_CombiWeight	30/01/2023 09:18:26	698
36	DatiStatistica_CombiWeight	30/01/2023 09:17:48	700		DatiStatistica_CombiWeight	30/01/2023 09:18:30	700
37	DatiStatistica_CombiWeight	30/01/2023 09:17:49	697		DatiStatistica_CombiWeight	30/01/2023 09:18:31	700
38	DatiStatistica_CombiWeight	30/01/2023 09:17:50	701		DatiStatistica_CombiWeight	30/01/2023 09:18:32	699
39	DatiStatistica_CombiWeight	30/01/2023 09:17:51	700		DatiStatistica_CombiWeight	30/01/2023 09:18:32	696
40	DatiStatistica_CombiWeight	30/01/2023 09:17:52	699		DatiStatistica_CombiWeight	30/01/2023 09:18:33	707
41	DatiStatistica_CombiWeight	30/01/2023 09:17:53	700		DatiStatistica_CombiWeight	30/01/2023 09:18:34	700
42	DatiStatistica_CombiWeight	30/01/2023 09:17:59	700		DatiStatistica_CombiWeight	30/01/2023 09:18:35	700
43	DatiStatistica_CombiWeight	30/01/2023 09:18:02	700		DatiStatistica_CombiWeight	30/01/2023 09:18:40	700
44	DatiStatistica_CombiWeight	30/01/2023 09:18:03	700		DatiStatistica_CombiWeight	30/01/2023 09:18:43	700
45	DatiStatistica_CombiWeight	30/01/2023 09:18:04	699		DatiStatistica_CombiWeight	30/01/2023 09:18:44	698
46	DatiStatistica_CombiWeight	30/01/2023 09:18:05	700		DatiStatistica_CombiWeight	30/01/2023 09:18:45	699
47	DatiStatistica_CombiWeight	30/01/2023 09:18:06	696		DatiStatistica_CombiWeight	30/01/2023 09:18:46	701
48	DatiStatistica_CombiWeight	30/01/2023 09:18:07	698		DatiStatistica_CombiWeight	30/01/2023 09:18:47	701
49	DatiStatistica_CombiWeight	30/01/2023 09:18:07	700		DatiStatistica_CombiWeight	30/01/2023 09:18:48	700
50	DatiStatistica_CombiWeight	30/01/2023 09:18:12	699		DatiStatistica_CombiWeight	30/01/2023 09:18:53	700
51	DatiStatistica_CombiWeight	30/01/2023 09:18:16	700		DatiStatistica_CombiWeight	30/01/2023 09:18:56	700
52	DatiStatistica_CombiWeight	30/01/2023 09:18:17	697		DatiStatistica_CombiWeight	30/01/2023 09:18:57	700
53	DatiStatistica_CombiWeight	30/01/2023 09:18:18	700		DatiStatistica_CombiWeight	30/01/2023 09:18:58	701
54	DatiStatistica_CombiWeight	30/01/2023 09:18:19	700		DatiStatistica_CombiWeight	30/01/2023 09:18:59	703
55	DatiStatistica_CombiWeight	30/01/2023 09:18:19	699		DatiStatistica_CombiWeight	30/01/2023 09:19:00	700
56	DatiStatistica_CombiWeight	30/01/2023 09:18:20	700		DatiStatistica_CombiWeight	30/01/2023 09:19:01	700
57	DatiStatistica_CombiWeight	30/01/2023 09:18:26	698		DatiStatistica_CombiWeight	30/01/2023 09:19:02	699
58	DatiStatistica_CombiWeight	30/01/2023 09:18:30	700
59	DatiStatistica_CombiWeight	30/01/2023 09:18:31	700
60	DatiStatistica_CombiWeight	30/01/2023 09:18:32	699
61	DatiStatistica_CombiWeight	30/01/2023 09:18:32	696
62	DatiStatistica_CombiWeight	30/01/2023 09:18:33	707
63	DatiStatistica_CombiWeight	30/01/2023 09:18:34	700
64	DatiStatistica_CombiWeight	30/01/2023 09:18:35	700
65	DatiStatistica_CombiWeight	30/01/2023 09:18:40	700
66	DatiStatistica_CombiWeight	30/01/2023 09:18:43	700
67	DatiStatistica_CombiWeight	30/01/2023 09:18:44	698
68	DatiStatistica_CombiWeight	30/01/2023 09:18:45	699
69	DatiStatistica_CombiWeight	30/01/2023 09:18:46	701
70	DatiStatistica_CombiWeight	30/01/2023 09:18:47	701
71	DatiStatistica_CombiWeight	30/01/2023 09:18:48	700
72	DatiStatistica_CombiWeight	30/01/2023 09:18:53	700
73	DatiStatistica_CombiWeight	30/01/2023 09:18:56	700
74	DatiStatistica_CombiWeight	30/01/2023 09:18:57	700
75	DatiStatistica_CombiWeight	30/01/2023 09:18:58	701
76	DatiStatistica_CombiWeight	30/01/2023 09:18:59	703
77	DatiStatistica_CombiWeight	30/01/2023 09:19:00	700
78	DatiStatistica_CombiWeight	30/01/2023 09:19:01	700
79	DatiStatistica_CombiWeight	30/01/2023 09:19:02	699
Sheet1

Cell Formulas
Range	Formula
E2:G57	E2	=FILTER(A2:C79,(A2:A79 ="DatiStatistica_CombiWeight")*(C2:C79<=$I$2),"")
Dynamic array formulas.

 

[fogarasia]

So it is not really. Not enough. If you see the table below the machine setting vary a lot over time. These are just the settings, which means, that after setting a new value the deviation will be around that setting. And the bigger problem is when we pack 500, after 600, and after 700 grams, and the deviation overlap is there. So it would be good, to not filter if there is a new TargetWeight for ex. after 500 we switch to 600, and then I will still look for the values around the 500 settings.

Statisztika feb02-09.xlsx
	D	E	F
3	DatiStatistica_TargetWeight	31/01/2023 22:49	500
4	DatiStatistica_TargetWeight	31/01/2023 22:49	500
5	DatiStatistica_TargetWeight	01/02/2023 07:55	600
6	DatiStatistica_TargetWeight	01/02/2023 08:22	600
7	DatiStatistica_TargetWeight	01/02/2023 14:40	700
8	DatiStatistica_TargetWeight	01/02/2023 14:43	700
9	DatiStatistica_TargetWeight	01/02/2023 14:44	700
10	DatiStatistica_TargetWeight	01/02/2023 14:46	700
11	DatiStatistica_TargetWeight	01/02/2023 14:48	700
12	DatiStatistica_TargetWeight	01/02/2023 16:55	700
13	DatiStatistica_TargetWeight	01/02/2023 17:00	1000
14	DatiStatistica_TargetWeight	01/02/2023 18:47	1000
15	DatiStatistica_TargetWeight	01/02/2023 18:55	1000
16	DatiStatistica_TargetWeight	01/02/2023 20:23	1000
17	DatiStatistica_TargetWeight	02/02/2023 04:08	1000
18	DatiStatistica_TargetWeight	02/02/2023 08:09	1500
19	DatiStatistica_TargetWeight	02/02/2023 08:10	1500
20	DatiStatistica_TargetWeight	02/02/2023 08:24	1500
21	DatiStatistica_TargetWeight	02/02/2023 11:08	1500
22	DatiStatistica_TargetWeight	02/02/2023 14:41	500
23	DatiStatistica_TargetWeight	02/02/2023 14:47	500
24	DatiStatistica_TargetWeight	02/02/2023 15:35	500
25	DatiStatistica_TargetWeight	02/06/2023 07:59	500
Munka2