Getting Invoice number for amount

[Geo Jul]

Dear All​

Please Help how to get invoices number for each month amount in Column G​

should read in column J Many Thanks in Advice Invoice no.​ Month​ Sales Figures​ Month Sales Figures by Month Month Invoice no. 190 BXJ​ 7-Oct-23​ 3827.00​ Jan-23​ 9760.00​ Jan-23​ 392 YGX,204 RRP,446 QRC,123 RBJ​ 126 ZHK​ 5-Jul-23​ 4207.00​ Feb-23​ 50089.00​ Feb-23​ 143 SPV​ 16-Oct-23​ 6069.00​ Mar-23​ 25962.00​ Mar-23​ 328 PMC​ 19-May-23​ 14112.00​ Apr-23​ 15316.00​ Apr-23​ 124 XNS​ 7-Jun-23​ 1341.00​ May-23​ 40216.00​ May-23​ 392 YGX​ 24-Apr-23​ 756.00​ Jun-23​ 18582.00​ Jun-23​ 280 HFS​ 31-Oct-23​ 11914.00​ Jul-23​ 42726.00​ Jul-23​ 386 HWK​ 13-Feb-23​ 13028.00​ Aug-23​ 19698.00​ Aug-23​ 333 MZG​ 19-Feb-23​ 12946.00​ Sep-23​ 19203.00​ Sep-23​ 345 ZVW​ 12-Mar-23​ 14295.00​ Oct-23​ 44209.00​ Oct-23​ 370 NRC​ 9-Nov-23​ 13267.00​ Nov-23​ 35391.00​ Nov-23​ 204 RRP​ 17-Apr-23​ 936.00​ Dec-23​ 23309.00​ Dec-23​ 408 KBF​ 2-Jul-23​ 14191.00​ 361 OYY​ 12-Dec-23​ 5097.00​ Total Sales​ 344461.00​ 173 INA​ 27-Aug-23​ 8253.00​ 133 VFC​ 5-Aug-23​ 8188.00​ 233 XBD​ 9-Jul-23​ 2131.00​ 240 GLO​ 25-May-23​ 8169.00​ 433 OQI​ 8-Nov-23​ 1802.00​ 355 CPF​ 26-Apr-23​ 13624.00​ 271 OXZ​ 15-May-23​ 3973.00​ 313 YGJ​ 14-Jun-23​ 2710.00​ 288 HSK​ 26-Oct-23​ 12335.00​ 387 EUE​ 16-Dec-23​ 5044.00​ 446 QRC​ 25-Jun-23​ 769.00​ 143 LOR​ 27-Nov-23​ 10286.00​ 446 AUC​ 5-Feb-23​ 6363.00​ 314 EAV​ 6-Mar-23​ 4025.00​ 273 NQX​ 15-Jul-23​ 5543.00​ 239 FFR​ 13-Oct-23​ 4821.00​ 338 YVD​ 7-Jun-23​ 1798.00​ 149 XJC​ 15-Dec-23​ 9804.00​ 316 VFL​ 28-Jan-23​ 4899.00​ 260 GDS​ 22-Feb-23​ 13733.00​ 280 BYW​ 22-Jul-23​ 10425.00​ 451 WXX​ 27-Aug-23​ 3257.00​ 421 TXB​ 6-May-23​ 13962.00​ 384 MPP​ 10-Nov-23​ 5474.00​ 431 EKK​ 13-Jun-23​ 11964.00​ 377 UKT​ 18-Jan-23​ 4861.00​ 228 MCD​ 25-Feb-23​ 4019.00​ 259 TFS​ 15-Oct-23​ 5243.00​ 184 WMM​ 17-Sep-23​ 12054.00​ 123 RBJ​ 17-Sep-23​ 742.00​ 428 YPF​ 11-Sep-23​ 1452.00​ 255 YUI​ 18-Sep-23​ 4955.00​ 353 LNM​ 9-Jul-23​ 6229.00​ 148 NLD​ 13-Nov-23​ 4562.00​ 159 SNV​ 13-Mar-23​ 7642.00​ 126 GPI​ 26-Dec-23​ 3364.00​ Total Sales​ 344461.00​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Invoice no.	Month	Sales Figures		Month	Sales Figures by Month		Month	Invoice no.
2	190 BXJ	07-Oct-23	3827		01/01/2023	9760		01/01/2023	316 VFL, 377 UKT
3	126 ZHK	05-Jul-23	4207		01/02/2023	50089		01/02/2023	386 HWK, 333 MZG, 446 AUC, 260 GDS, 228 MCD
4	143 SPV	16-Oct-23	6069		01/03/2023	25962		01/03/2023	345 ZVW, 314 EAV, 159 SNV
5	328 PMC	19-May-23	14112		01/04/2023	15316		01/04/2023	392 YGX, 204 RRP, 355 CPF
6	124 XNS	07-Jun-23	1341		01/05/2023	40216		01/05/2023	328 PMC, 240 GLO, 271 OXZ, 421 TXB
7	392 YGX	24-Apr-23	756		01/06/2023	18582		01/06/2023	124 XNS, 313 YGJ, 446 QRC, 338 YVD, 431 EKK
8	280 HFS	31-Oct-23	11914		01/07/2023	42726		01/07/2023	126 ZHK, 408 KBF, 233 XBD, 273 NQX, 280 BYW, 353 LNM
9	386 HWK	13-Feb-23	13028		01/08/2023	19698		01/08/2023	173 INA, 133 VFC, 451 WXX
10	333 MZG	19-Feb-23	12946		01/09/2023	19203		01/09/2023	184 WMM, 123 RBJ, 428 YPF, 255 YUI
11	345 ZVW	12-Mar-23	14295		01/10/2023	44209		01/10/2023	190 BXJ, 143 SPV, 280 HFS, 288 HSK, 239 FFR, 259 TFS
12	370 NRC	09-Nov-23	13267		01/11/2023	35391		01/11/2023	370 NRC, 433 OQI, 143 LOR, 384 MPP, 148 NLD
13	204 RRP	17-Apr-23	936		01/12/2023	23309		01/12/2023	361 OYY, 387 EUE, 149 XJC, 126 GPI
14	408 KBF	02-Jul-23	14191
15	361 OYY	12-Dec-23	5097		Total Sales	344461
16	173 INA	27-Aug-23	8253
17	133 VFC	05-Aug-23	8188
18	233 XBD	09-Jul-23	2131
19	240 GLO	25-May-23	8169
20	433 OQI	08-Nov-23	1802
21	355 CPF	26-Apr-23	13624
22	271 OXZ	15-May-23	3973
23	313 YGJ	14-Jun-23	2710
24	288 HSK	26-Oct-23	12335
25	387 EUE	16-Dec-23	5044
26	446 QRC	25-Jun-23	769
27	143 LOR	27-Nov-23	10286
28	446 AUC	05-Feb-23	6363
29	314 EAV	06-Mar-23	4025
30	273 NQX	15-Jul-23	5543
31	239 FFR	13-Oct-23	4821
32	338 YVD	07-Jun-23	1798
33	149 XJC	15-Dec-23	9804
34	316 VFL	28-Jan-23	4899
35	260 GDS	22-Feb-23	13733
36	280 BYW	22-Jul-23	10425
37	451 WXX	27-Aug-23	3257
38	421 TXB	06-May-23	13962
39	384 MPP	10-Nov-23	5474
40	431 EKK	13-Jun-23	11964
41	377 UKT	18-Jan-23	4861
42	228 MCD	25-Feb-23	4019
43	259 TFS	15-Oct-23	5243
44	184 WMM	17-Sep-23	12054
45	123 RBJ	17-Sep-23	742
46	428 YPF	11-Sep-23	1452
47	255 YUI	18-Sep-23	4955
48	353 LNM	09-Jul-23	6229
49	148 NLD	13-Nov-23	4562
50	159 SNV	13-Mar-23	7642
51	126 GPI	26-Dec-23	3364
52
53		Total Sales	344461
54
Main

Cell Formulas
Range	Formula
I2:I13	I2	=TEXTJOIN(", ",,FILTER($A$2:$A$100,($B$2:$B$100>=H2)*($B$2:$B$100<EDATE(H2,1)),""))

 

[Geo Jul]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Invoice no.	Month	Sales Figures		Month	Sales Figures by Month		Month	Invoice no.
2	190 BXJ	07-Oct-23	3827		01/01/2023	9760		01/01/2023	316 VFL, 377 UKT
3	126 ZHK	05-Jul-23	4207		01/02/2023	50089		01/02/2023	386 HWK, 333 MZG, 446 AUC, 260 GDS, 228 MCD
4	143 SPV	16-Oct-23	6069		01/03/2023	25962		01/03/2023	345 ZVW, 314 EAV, 159 SNV
5	328 PMC	19-May-23	14112		01/04/2023	15316		01/04/2023	392 YGX, 204 RRP, 355 CPF
6	124 XNS	07-Jun-23	1341		01/05/2023	40216		01/05/2023	328 PMC, 240 GLO, 271 OXZ, 421 TXB
7	392 YGX	24-Apr-23	756		01/06/2023	18582		01/06/2023	124 XNS, 313 YGJ, 446 QRC, 338 YVD, 431 EKK
8	280 HFS	31-Oct-23	11914		01/07/2023	42726		01/07/2023	126 ZHK, 408 KBF, 233 XBD, 273 NQX, 280 BYW, 353 LNM
9	386 HWK	13-Feb-23	13028		01/08/2023	19698		01/08/2023	173 INA, 133 VFC, 451 WXX
10	333 MZG	19-Feb-23	12946		01/09/2023	19203		01/09/2023	184 WMM, 123 RBJ, 428 YPF, 255 YUI
11	345 ZVW	12-Mar-23	14295		01/10/2023	44209		01/10/2023	190 BXJ, 143 SPV, 280 HFS, 288 HSK, 239 FFR, 259 TFS
12	370 NRC	09-Nov-23	13267		01/11/2023	35391		01/11/2023	370 NRC, 433 OQI, 143 LOR, 384 MPP, 148 NLD
13	204 RRP	17-Apr-23	936		01/12/2023	23309		01/12/2023	361 OYY, 387 EUE, 149 XJC, 126 GPI
14	408 KBF	02-Jul-23	14191
15	361 OYY	12-Dec-23	5097		Total Sales	344461
16	173 INA	27-Aug-23	8253
17	133 VFC	05-Aug-23	8188
18	233 XBD	09-Jul-23	2131
19	240 GLO	25-May-23	8169
20	433 OQI	08-Nov-23	1802
21	355 CPF	26-Apr-23	13624
22	271 OXZ	15-May-23	3973
23	313 YGJ	14-Jun-23	2710
24	288 HSK	26-Oct-23	12335
25	387 EUE	16-Dec-23	5044
26	446 QRC	25-Jun-23	769
27	143 LOR	27-Nov-23	10286
28	446 AUC	05-Feb-23	6363
29	314 EAV	06-Mar-23	4025
30	273 NQX	15-Jul-23	5543
31	239 FFR	13-Oct-23	4821
32	338 YVD	07-Jun-23	1798
33	149 XJC	15-Dec-23	9804
34	316 VFL	28-Jan-23	4899
35	260 GDS	22-Feb-23	13733
36	280 BYW	22-Jul-23	10425
37	451 WXX	27-Aug-23	3257
38	421 TXB	06-May-23	13962
39	384 MPP	10-Nov-23	5474
40	431 EKK	13-Jun-23	11964
41	377 UKT	18-Jan-23	4861
42	228 MCD	25-Feb-23	4019
43	259 TFS	15-Oct-23	5243
44	184 WMM	17-Sep-23	12054
45	123 RBJ	17-Sep-23	742
46	428 YPF	11-Sep-23	1452
47	255 YUI	18-Sep-23	4955
48	353 LNM	09-Jul-23	6229
49	148 NLD	13-Nov-23	4562
50	159 SNV	13-Mar-23	7642
51	126 GPI	26-Dec-23	3364
52
53		Total Sales	344461
54
Main

Cell Formulas
Range	Formula
I2:I13	I2	=TEXTJOIN(", ",,FILTER($A$2:$A$100,($B$2:$B$100>=H2)*($B$2:$B$100<EDATE(H2,1)),""))

Thank you very Much for help

 

[Fluff]

You're welcome & thanks for the feedback.