Automatically generate dates depending on cell

[AlexiT4444]

Hello,

I am in the process of extracting data, but I cannot find anything online which can help me. What I am trying to do is insert the date of the first date they dispatched and the last date they were dispatched and automatically input this data in columns B and C.

Any help would be much appreciated.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	ID	First Dispatch	Last Dispatch	27/10/2019	28/10/2019	29/10/2019	30/10/2019	31/10/2019	01/11/2019	02/11/2019	03/11/2019	04/11/2019	05/11/2019	06/11/2019	07/11/2019	08/11/2019	09/11/2019	10/11/2019	11/11/2019	12/11/2019	13/11/2019	14/11/2019	15/11/2019	16/11/2019	17/11/2019	18/11/2019	19/11/2019	20/11/2019	21/11/2019	22/11/2019	23/11/2019	24/11/2019
2	1			0	63	52	48	0	47	73	0	66	68	87	109	76	61	0	107	76	80	91	85	0	0	101	97	85	84	77	111	0
3	2			0	0	0	0	0	77	75	0	0	0	0	0	51	0															0
4	3			0	73	50	45	0	60	56	0	60	51	69	76	64	40	0	80	71	65	82	68	0	0	66	85	107	0	69	104	0
5	4			0	0	49	0	0	0	0
6	5			0	29	57	60	0	65	77	0	55	56	100	79	87	53	0	70	66	52	111	54	0	0	73	112	76	56	60	0	0
7	6			0	53	50	51	0	27	64	0	48	70	88	106	72	0	0	83	0	0	98	61	0	0	92	98	69	60	66	0	0
8	7			0	62	75	57	0	56	59	0	71	41	84	100	0	0	0	0	0	0	0	0	0
9	8			0	78	47	43	0	46	84	0	71	81	93	125	87	53	0	89	76	76	106	54	91	0	52	41	91	58	104	0	0
10	9			0	0	0	40	0	108	79	0	87	69	77	75	93	63	0	26	117	69	87	45	0	0	95	27	57	60	46	91	0
11	10			0	88	55	55	0	87	66	0	71	73	78	96	81	56	0	83	84	66	0	86	0	0	82	0	95	75	94	96	0
12	11			0	55	57	42	0	45	81	0	80	85	92	117	84	60	0	85	70	67	105	88	0	0	99	124	86	95	112	0	0
13	12			0	65	40	41	0	45	61	0	66	59	87	98	87	0	0	100	0	0	115	79	0	0	98	110	97	90	102	0	0
14	13										0	46	59	50	67	69	71	0	83	65	58	98	0	52	0	76	86	78	54	82	98	0
15	14										0	48	42	50	45	75	73	0	78	75	67	109	66	0	0	70	109	90	94	87	112	0
16	15										0	33	54	60	42	61	66	0	81	79	55	80	69	0	0	105	84	88	98	73	90	0
17	16										0	51	48	47	50	74	66	0	64	83	81	103	55	0								0
18	17										0	0	0	53	43	48	64
19	18										0	0	0	0	0	57	54	0	56	44	60	76	91	81	0	91	131	98	87	97	124	0
20	19										0	43	32	51	56	51	62	0	47	71	76	92	0	81	0	90	76	78	56	70	96	0
21	20																	0	38	40	47	42	83	62	0	69	70	80	0	78	83	0
22	21																	0	45	50	51	42	79	67	0	66	81	67	0	68	99	0
23	22																	0	0	0	0	0	0	62	0	55	58	60	96	56	90	0
24	23																	0	45	44	53	53	75	68	0	64	96	82	69	84	104	0
25	24																	0	0	37	46	32	37	58	0	73	82	76	92	85	121	0
26	25																	0	0	47	39	47	46	78	0	82	83	91	0	85	91	0
27	26																	0	21	30	46	33	0	0
28	27																	0	56	45	53	52	69	89	0	83	87	87	89	85	123	0
29	28																	0	53	44	53	47	87	80	0	90	63	76	83	84	115	0
30	29																	0	48	43	54	48	80	75	0	112	75	109	74	84	111	0
31	30																	0	0	39	35	46	27	84	0	85	54	58	65	82	109	0
32	31																	0	53	50	59	55	63	49	0	0	0	87	88	90	103	0
33	32																	0	68	48	57	47	100	93	0	93	89	87	0	94	93	0
34	33																	0	46	47	48	60	97	65	0	68	75	96	80	82	97	0
35	34																	0	52	50	57	42	96	84	0	94	93	87	103	91	138	0
36	35																	0	0	0	0	54	54	39	0	49	100	82	66	81	93	0
37	36																	0	45	59	45	55	73	90	0	0	0	0	0	0	0	0
38	37																	0	53	51	47	56	81	82	0	89	72	96	66	65	104	0
39	38																	0	52	36	58	55	84	71	0	81	88	70	0	102	107	0
40	39																								0	0	0	0	0	56	60	0
41	40																								0	0	0	0	47	58	49	0
42	41																								0	0	0	85	0	0	0
43	42																								0	0	0	64	0	0	126	0
44	43																								0	0	0	65	0	0	80	0
45	44																								0	0	0	101	0	0	89	0
46	45																								0	0	0	57	0	0	135	0
47	46																								0	0	0	19	0	0	0
48	47																								0	0	0	49	0	0	0
49	48																								0	0	0	0	52	52	70	0
50	49																								0	0	0	0	0	0	114	0
51	50																								0	0	0	0	0	57	56	0
52	51																								0	0	0	45	0	0	106	0
53	52																								0	0	0	73	0	0	0
54	53																								0	0	0	0	35	0	0
55	54																								0	0	0	47	0	0	112	0
Sheet1

 

[etaf]

=MINIFS($D$1:$AF$1,D2:AF2,"<>"&0,D2:AF2,"<>"&"")
=MAXIFS($D$1:$AF$1,D2:AF2,"<>"&0,D2:AF2,"<>"&"")

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	ID	First Dispatch	Last Dispatch	10/27/19	10/28/19	10/29/19	10/30/19	10/31/19	11/1/19	11/2/19	11/3/19	11/4/19	11/5/19	11/6/19	11/7/19	11/8/19	11/9/19	11/10/19	11/11/19	11/12/19	11/13/19	11/14/19	11/15/19	11/16/19	11/17/19	11/18/19	11/19/19	11/20/19	11/21/19	11/22/19	11/23/19	11/24/19
2	1	10/28/19	11/23/19	0	63	52	48	0	47	73	0	66	68	87	109	76	61	0	107	76	80	91	85	0	0	101	97	85	84	77	111	0
3	2	11/1/19	11/8/19	0	0	0	0	0	77	75	0	0	0	0	0	51	0															0
4	3	10/28/19	11/23/19	0	73	50	45	0	60	56	0	60	51	69	76	64	40	0	80	71	65	82	68	0	0	66	85	107	0	69	104	0
5	4	10/29/19	10/29/19	0	0	49	0	0	0	0
6	5	10/28/19	11/22/19	0	29	57	60	0	65	77	0	55	56	100	79	87	53	0	70	66	52	111	54	0	0	73	112	76	56	60	0	0
7	6	10/28/19	11/22/19	0	53	50	51	0	27	64	0	48	70	88	106	72	0	0	83	0	0	98	61	0	0	92	98	69	60	66	0	0
8	7	10/28/19	11/7/19	0	62	75	57	0	56	59	0	71	41	84	100	0	0	0	0	0	0	0	0	0
9	8	10/28/19	11/22/19	0	78	47	43	0	46	84	0	71	81	93	125	87	53	0	89	76	76	106	54	91	0	52	41	91	58	104	0	0
10	9	10/30/19	11/23/19	0	0	0	40	0	108	79	0	87	69	77	75	93	63	0	26	117	69	87	45	0	0	95	27	57	60	46	91	0
11	10	10/28/19	11/23/19	0	88	55	55	0	87	66	0	71	73	78	96	81	56	0	83	84	66	0	86	0	0	82	0	95	75	94	96	0
12	11	10/28/19	11/22/19	0	55	57	42	0	45	81	0	80	85	92	117	84	60	0	85	70	67	105	88	0	0	99	124	86	95	112	0	0
13	12	10/28/19	11/22/19	0	65	40	41	0	45	61	0	66	59	87	98	87	0	0	100	0	0	115	79	0	0	98	110	97	90	102	0	0
14	13	11/4/19	11/23/19								0	46	59	50	67	69	71	0	83	65	58	98	0	52	0	76	86	78	54	82	98	0
15	14	11/4/19	11/23/19								0	48	42	50	45	75	73	0	78	75	67	109	66	0	0	70	109	90	94	87	112	0
16	15	11/4/19	11/23/19								0	33	54	60	42	61	66	0	81	79	55	80	69	0	0	105	84	88	98	73	90	0
17	16	11/4/19	11/15/19								0	51	48	47	50	74	66	0	64	83	81	103	55	0								0
18	17	11/6/19	11/9/19								0	0	0	53	43	48	64
19	18	11/8/19	11/23/19								0	0	0	0	0	57	54	0	56	44	60	76	91	81	0	91	131	98	87	97	124	0
20	19	11/4/19	11/23/19								0	43	32	51	56	51	62	0	47	71	76	92	0	81	0	90	76	78	56	70	96	0
21	20	11/11/19	11/23/19															0	38	40	47	42	83	62	0	69	70	80	0	78	83	0
22	21	11/11/19	11/23/19															0	45	50	51	42	79	67	0	66	81	67	0	68	99	0
23	22	11/16/19	11/23/19															0	0	0	0	0	0	62	0	55	58	60	96	56	90	0
24	23	11/11/19	11/23/19															0	45	44	53	53	75	68	0	64	96	82	69	84	104	0
25	24	11/12/19	11/23/19															0	0	37	46	32	37	58	0	73	82	76	92	85	121	0
26	25	11/12/19	11/23/19															0	0	47	39	47	46	78	0	82	83	91	0	85	91	0
27	26	11/11/19	11/14/19															0	21	30	46	33	0	0
28	27	11/11/19	11/23/19															0	56	45	53	52	69	89	0	83	87	87	89	85	123	0
29	28	11/11/19	11/23/19															0	53	44	53	47	87	80	0	90	63	76	83	84	115	0
30	29	11/11/19	11/23/19															0	48	43	54	48	80	75	0	112	75	109	74	84	111	0
31	30	11/12/19	11/23/19															0	0	39	35	46	27	84	0	85	54	58	65	82	109	0
32	31	11/11/19	11/23/19															0	53	50	59	55	63	49	0	0	0	87	88	90	103	0
33	32	11/11/19	11/23/19															0	68	48	57	47	100	93	0	93	89	87	0	94	93	0
34	33	11/11/19	11/23/19															0	46	47	48	60	97	65	0	68	75	96	80	82	97	0
35	34	11/11/19	11/23/19															0	52	50	57	42	96	84	0	94	93	87	103	91	138	0
36	35	11/14/19	11/23/19															0	0	0	0	54	54	39	0	49	100	82	66	81	93	0
37	36	11/11/19	11/16/19															0	45	59	45	55	73	90	0	0	0	0	0	0	0	0
38	37	11/11/19	11/23/19															0	53	51	47	56	81	82	0	89	72	96	66	65	104	0
39	38	11/11/19	11/23/19															0	52	36	58	55	84	71	0	81	88	70	0	102	107	0
40	39	11/22/19	11/23/19																						0	0	0	0	0	56	60	0
41	40	11/21/19	11/23/19																						0	0	0	0	47	58	49	0
42	41	11/20/19	11/20/19																						0	0	0	85	0	0	0
43	42	11/20/19	11/23/19																						0	0	0	64	0	0	126	0
44	43	11/20/19	11/23/19																						0	0	0	65	0	0	80	0
45	44	11/20/19	11/23/19																						0	0	0	101	0	0	89	0
46	45	11/20/19	11/23/19																						0	0	0	57	0	0	135	0
47	46	11/20/19	11/20/19																						0	0	0	19	0	0	0
48	47	11/20/19	11/20/19																						0	0	0	49	0	0	0
49	48	11/21/19	11/23/19																						0	0	0	0	52	52	70	0
50	49	11/23/19	11/23/19																						0	0	0	0	0	0	114	0
51	50	11/22/19	11/23/19																						0	0	0	0	0	57	56	0
52	51	11/20/19	11/23/19																						0	0	0	45	0	0	106	0
53	52	11/20/19	11/20/19																						0	0	0	73	0	0	0
54	53	11/21/19	11/21/19																						0	0	0	0	35	0	0
55	54	11/20/19	11/23/19																						0	0	0	47	0	0	112	0
Sheet1

Cell Formulas
Range	Formula
B2:B55	B2	=MINIFS($D$1:$AF$1,D2:AF2,"<>"&0,D2:AF2,"<>"&"")
C2:C55	C2	=MAXIFS($D$1:$AF$1,D2:AF2,"<>"&0,D2:AF2,"<>"&"")

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	ID	First Dispatch	Last Dispatch	27/10/2019	28/10/2019	29/10/2019	30/10/2019	31/10/2019	01/11/2019	02/11/2019	03/11/2019	04/11/2019	05/11/2019	06/11/2019	07/11/2019	08/11/2019	09/11/2019	10/11/2019	11/11/2019	12/11/2019	13/11/2019	14/11/2019	15/11/2019	16/11/2019	17/11/2019	18/11/2019	19/11/2019	20/11/2019	21/11/2019	22/11/2019	23/11/2019	24/11/2019
2	1	28/10/2019	23/11/2019	0	63	52	48	0	47	73	0	66	68	87	109	76	61	0	107	76	80	91	85	0	0	101	97	85	84	77	111	0
3	2	01/11/2019	08/11/2019	0	0	0	0	0	77	75	0	0	0	0	0	51	0															0
4	3	28/10/2019	23/11/2019	0	73	50	45	0	60	56	0	60	51	69	76	64	40	0	80	71	65	82	68	0	0	66	85	107	0	69	104	0
5	4	29/10/2019	29/10/2019	0	0	49	0	0	0	0
6	5	28/10/2019	22/11/2019	0	29	57	60	0	65	77	0	55	56	100	79	87	53	0	70	66	52	111	54	0	0	73	112	76	56	60	0	0
7	6	28/10/2019	22/11/2019	0	53	50	51	0	27	64	0	48	70	88	106	72	0	0	83	0	0	98	61	0	0	92	98	69	60	66	0	0
8	7	28/10/2019	07/11/2019	0	62	75	57	0	56	59	0	71	41	84	100	0	0	0	0	0	0	0	0	0
9	8	28/10/2019	22/11/2019	0	78	47	43	0	46	84	0	71	81	93	125	87	53	0	89	76	76	106	54	91	0	52	41	91	58	104	0	0
10	9	30/10/2019	23/11/2019	0	0	0	40	0	108	79	0	87	69	77	75	93	63	0	26	117	69	87	45	0	0	95	27	57	60	46	91	0
11	10	28/10/2019	23/11/2019	0	88	55	55	0	87	66	0	71	73	78	96	81	56	0	83	84	66	0	86	0	0	82	0	95	75	94	96	0
12	11	28/10/2019	22/11/2019	0	55	57	42	0	45	81	0	80	85	92	117	84	60	0	85	70	67	105	88	0	0	99	124	86	95	112	0	0
13	12	28/10/2019	22/11/2019	0	65	40	41	0	45	61	0	66	59	87	98	87	0	0	100	0	0	115	79	0	0	98	110	97	90	102	0	0
14	13	04/11/2019	23/11/2019								0	46	59	50	67	69	71	0	83	65	58	98	0	52	0	76	86	78	54	82	98	0
15	14	04/11/2019	23/11/2019								0	48	42	50	45	75	73	0	78	75	67	109	66	0	0	70	109	90	94	87	112	0
16	15	04/11/2019	23/11/2019								0	33	54	60	42	61	66	0	81	79	55	80	69	0	0	105	84	88	98	73	90	0
17	16	04/11/2019	15/11/2019								0	51	48	47	50	74	66	0	64	83	81	103	55	0								0
18	17	06/11/2019	09/11/2019								0	0	0	53	43	48	64
19	18	08/11/2019	23/11/2019								0	0	0	0	0	57	54	0	56	44	60	76	91	81	0	91	131	98	87	97	124	0
20	19	04/11/2019	23/11/2019								0	43	32	51	56	51	62	0	47	71	76	92	0	81	0	90	76	78	56	70	96	0
21	20	11/11/2019	23/11/2019															0	38	40	47	42	83	62	0	69	70	80	0	78	83	0
22	21	11/11/2019	23/11/2019															0	45	50	51	42	79	67	0	66	81	67	0	68	99	0
23	22	16/11/2019	23/11/2019															0	0	0	0	0	0	62	0	55	58	60	96	56	90	0
24	23	11/11/2019	23/11/2019															0	45	44	53	53	75	68	0	64	96	82	69	84	104	0
25	24	12/11/2019	23/11/2019															0	0	37	46	32	37	58	0	73	82	76	92	85	121	0
26	25	12/11/2019	23/11/2019															0	0	47	39	47	46	78	0	82	83	91	0	85	91	0
27	26	11/11/2019	14/11/2019															0	21	30	46	33	0	0
28	27	11/11/2019	23/11/2019															0	56	45	53	52	69	89	0	83	87	87	89	85	123	0
29	28	11/11/2019	23/11/2019															0	53	44	53	47	87	80	0	90	63	76	83	84	115	0
30	29	11/11/2019	23/11/2019															0	48	43	54	48	80	75	0	112	75	109	74	84	111	0
31	30	12/11/2019	23/11/2019															0	0	39	35	46	27	84	0	85	54	58	65	82	109	0
32	31	11/11/2019	23/11/2019															0	53	50	59	55	63	49	0	0	0	87	88	90	103	0
33	32	11/11/2019	23/11/2019															0	68	48	57	47	100	93	0	93	89	87	0	94	93	0
34	33	11/11/2019	23/11/2019															0	46	47	48	60	97	65	0	68	75	96	80	82	97	0
35	34	11/11/2019	23/11/2019															0	52	50	57	42	96	84	0	94	93	87	103	91	138	0
36	35	14/11/2019	23/11/2019															0	0	0	0	54	54	39	0	49	100	82	66	81	93	0
37	36	11/11/2019	16/11/2019															0	45	59	45	55	73	90	0	0	0	0	0	0	0	0
38	37	11/11/2019	23/11/2019															0	53	51	47	56	81	82	0	89	72	96	66	65	104	0
39	38	11/11/2019	23/11/2019															0	52	36	58	55	84	71	0	81	88	70	0	102	107	0
40	39	22/11/2019	23/11/2019																						0	0	0	0	0	56	60	0
41	40	21/11/2019	23/11/2019																						0	0	0	0	47	58	49	0
42	41	20/11/2019	20/11/2019																						0	0	0	85	0	0	0
43	42	20/11/2019	23/11/2019																						0	0	0	64	0	0	126	0
44	43	20/11/2019	23/11/2019																						0	0	0	65	0	0	80	0
45	44	20/11/2019	23/11/2019																						0	0	0	101	0	0	89	0
46	45	20/11/2019	23/11/2019																						0	0	0	57	0	0	135	0
47	46	20/11/2019	20/11/2019																						0	0	0	19	0	0	0
48	47	20/11/2019	20/11/2019																						0	0	0	49	0	0	0
49	48	21/11/2019	23/11/2019																						0	0	0	0	52	52	70	0
50	49	23/11/2019	23/11/2019																						0	0	0	0	0	0	114	0
51	50	22/11/2019	23/11/2019																						0	0	0	0	0	57	56	0
52	51	20/11/2019	23/11/2019																						0	0	0	45	0	0	106	0
53	52	20/11/2019	20/11/2019																						0	0	0	73	0	0	0
54	53	21/11/2019	21/11/2019																						0	0	0	0	35	0	0
55	54	20/11/2019	23/11/2019																						0	0	0	47	0	0	112	0
Data

Cell Formulas
Range	Formula
B2:B55	B2	=INDEX($D$1:$AF$1,AGGREGATE(15,6,(COLUMN($D$1:$AF$1)-COLUMN($D$1)+1)/($D2:$AF2>0),1))
C2:C55	C2	=INDEX($D$1:$AF$1,AGGREGATE(14,6,(COLUMN($D$1:$AF$1)-COLUMN($D$1)+1)/($D2:$AF2>0),1))

 

[Dossfm0q]

What about

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	ID	First Dispatch	Last Dispatch	27/10/2019	28/10/2019	29/10/2019	30/10/2019	31/10/2019	01/11/2019	02/11/2019	03/11/2019	04/11/2019	05/11/2019	06/11/2019	07/11/2019	08/11/2019	09/11/2019	10/11/2019	11/11/2019	12/11/2019	13/11/2019	14/11/2019	15/11/2019	16/11/2019	17/11/2019	18/11/2019	19/11/2019	20/11/2019	21/11/2019	22/11/2019	23/11/2019	24/11/2019
2	1	27/10/2019	24/11/2019	0	63	52	48	0	47	73	0	66	68	87	109	76	61	0	107	76	80	91	85	0	0	101	97	85	84	77	111	0
3	2	27/10/2019	24/11/2019	0	0	0	0	0	77	75	0	0	0	0	0	51	0															0
4	3	27/10/2019	24/11/2019	0	73	50	45	0	60	56	0	60	51	69	76	64	40	0	80	71	65	82	68	0	0	66	85	107	0	69	104	0
5	4	27/10/2019	02/11/2019	0	0	49	0	0	0	0
6	5	27/10/2019	24/11/2019	0	29	57	60	0	65	77	0	55	56	100	79	87	53	0	70	66	52	111	54	0	0	73	112	76	56	60	0	0
7	6	27/10/2019	24/11/2019	0	53	50	51	0	27	64	0	48	70	88	106	72	0	0	83	0	0	98	61	0	0	92	98	69	60	66	0	0
8	7	27/10/2019	16/11/2019	0	62	75	57	0	56	59	0	71	41	84	100	0	0	0	0	0	0	0	0	0
9	8	27/10/2019	24/11/2019	0	78	47	43	0	46	84	0	71	81	93	125	87	53	0	89	76	76	106	54	91	0	52	41	91	58	104	0	0
10	9	27/10/2019	24/11/2019	0	0	0	40	0	108	79	0	87	69	77	75	93	63	0	26	117	69	87	45	0	0	95	27	57	60	46	91	0
11	10	27/10/2019	24/11/2019	0	88	55	55	0	87	66	0	71	73	78	96	81	56	0	83	84	66	0	86	0	0	82	0	95	75	94	96	0
12	11	27/10/2019	24/11/2019	0	55	57	42	0	45	81	0	80	85	92	117	84	60	0	85	70	67	105	88	0	0	99	124	86	95	112	0	0
13	12	27/10/2019	24/11/2019	0	65	40	41	0	45	61	0	66	59	87	98	87	0	0	100	0	0	115	79	0	0	98	110	97	90	102	0	0
14	13	03/11/2019	24/11/2019								0	46	59	50	67	69	71	0	83	65	58	98	0	52	0	76	86	78	54	82	98	0
15	14	03/11/2019	24/11/2019								0	48	42	50	45	75	73	0	78	75	67	109	66	0	0	70	109	90	94	87	112	0
16	15	03/11/2019	24/11/2019								0	33	54	60	42	61	66	0	81	79	55	80	69	0	0	105	84	88	98	73	90	0
17	16	03/11/2019	24/11/2019								0	51	48	47	50	74	66	0	64	83	81	103	55	0								0
18	17	03/11/2019	09/11/2019								0	0	0	53	43	48	64
19	18	03/11/2019	24/11/2019								0	0	0	0	0	57	54	0	56	44	60	76	91	81	0	91	131	98	87	97	124	0
20	19	03/11/2019	24/11/2019								0	43	32	51	56	51	62	0	47	71	76	92	0	81	0	90	76	78	56	70	96	0
21	20	10/11/2019	24/11/2019															0	38	40	47	42	83	62	0	69	70	80	0	78	83	0
22	21	10/11/2019	24/11/2019															0	45	50	51	42	79	67	0	66	81	67	0	68	99	0
23	22	10/11/2019	24/11/2019															0	0	0	0	0	0	62	0	55	58	60	96	56	90	0
24	23	10/11/2019	24/11/2019															0	45	44	53	53	75	68	0	64	96	82	69	84	104	0
25	24	10/11/2019	24/11/2019															0	0	37	46	32	37	58	0	73	82	76	92	85	121	0
26	25	10/11/2019	24/11/2019															0	0	47	39	47	46	78	0	82	83	91	0	85	91	0
27	26	10/11/2019	16/11/2019															0	21	30	46	33	0	0
28	27	10/11/2019	24/11/2019															0	56	45	53	52	69	89	0	83	87	87	89	85	123	0
29	28	10/11/2019	24/11/2019															0	53	44	53	47	87	80	0	90	63	76	83	84	115	0
30	29	10/11/2019	24/11/2019															0	48	43	54	48	80	75	0	112	75	109	74	84	111	0
31	30	10/11/2019	24/11/2019															0	0	39	35	46	27	84	0	85	54	58	65	82	109	0
32	31	10/11/2019	24/11/2019															0	53	50	59	55	63	49	0	0	0	87	88	90	103	0
33	32	10/11/2019	24/11/2019															0	68	48	57	47	100	93	0	93	89	87	0	94	93	0
34	33	10/11/2019	24/11/2019															0	46	47	48	60	97	65	0	68	75	96	80	82	97	0
35	34	10/11/2019	24/11/2019															0	52	50	57	42	96	84	0	94	93	87	103	91	138	0
36	35	10/11/2019	24/11/2019															0	0	0	0	54	54	39	0	49	100	82	66	81	93	0
37	36	10/11/2019	24/11/2019															0	45	59	45	55	73	90	0	0	0	0	0	0	0	0
38	37	10/11/2019	24/11/2019															0	53	51	47	56	81	82	0	89	72	96	66	65	104	0
39	38	10/11/2019	24/11/2019															0	52	36	58	55	84	71	0	81	88	70	0	102	107	0
40	39	17/11/2019	24/11/2019																						0	0	0	0	0	56	60	0
41	40	17/11/2019	24/11/2019																						0	0	0	0	47	58	49	0
42	41	17/11/2019	23/11/2019																						0	0	0	85	0	0	0
43	42	17/11/2019	24/11/2019																						0	0	0	64	0	0	126	0
44	43	17/11/2019	24/11/2019																						0	0	0	65	0	0	80	0
45	44	17/11/2019	24/11/2019																						0	0	0	101	0	0	89	0
46	45	17/11/2019	24/11/2019																						0	0	0	57	0	0	135	0
47	46	17/11/2019	23/11/2019																						0	0	0	19	0	0	0
48	47	17/11/2019	23/11/2019																						0	0	0	49	0	0	0
49	48	17/11/2019	24/11/2019																						0	0	0	0	52	52	70	0
50	49	17/11/2019	24/11/2019																						0	0	0	0	0	0	114	0
51	50	17/11/2019	24/11/2019																						0	0	0	0	0	57	56	0
52	51	17/11/2019	24/11/2019																						0	0	0	45	0	0	106	0
53	52	17/11/2019	23/11/2019																						0	0	0	73	0	0	0
54	53	17/11/2019	23/11/2019																						0	0	0	0	35	0	0
55	54	17/11/2019	24/11/2019																						0	0	0	47	0	0	112	0
Sheet3

Cell Formulas
Range	Formula
B2:B55	B2	=INDEX($D$1:$AF$1,1,AGGREGATE(15,6,(COLUMN($D2:$AF2)-COLUMN($D2)+1)/(--($D2:$AF2<>"")),1))
C2:C55	C2	=INDEX($D$1:$AF$1,1,AGGREGATE(14,6,(COLUMN($D2:$AF2)-COLUMN($D2)+1)/(--($D2:$AF2<>"")),1))

 

[Phuoc]

Or try:

B2=AGGREGATE(15,6,$D$1:$AF$1/(D2:AF2<>0),1)

C2=AGGREGATE(14,6,$D$1:$AF$1/(D2:AF2<>0),1)

 

[AlexiT4444]

Hi,

They all work, thanks alot!

 

[Fluff]

Glad we could help & thanks for the feedback.