Invoice number between range
| | | | | | | | | | | | Serial no. | Invoice no. | Month | Sales Figures | | Sale Range | Amounts between
Sales range | Invoice no. | | | | | | 1 | 190 BXJ | 7-Oct-23 | $ 3,827.00 | | 1-999 | 756,936,769,742 | 392 YGX,204 RRP,446 QRC,123 RBJ | the result should read like this | | | | | 2 | 126 ZHK | 5-Jul-23 | $ 4,207.00 | | 1000-1999 | 1341,1802,1798,1452 | | | | | | | 3 | 143 SPV | 16-Oct-23 | $ 6,069.00 | | 2000-2999 | 2131,2710 | | | | | | | 4 | 328 PMC | 19-May-23 | $ 14,112.00 | | 3000-3999 | 3827,3973,3257,3364 | | | | | | | 5 | 124 XNS | 7-Jun-23 | $ 1,341.00 | | 4000-4999 | 4207,4025,4821,4899,4861,4019,4955,4562 | | | | | | | 6 | 392 YGX | 24-Apr-23 | $ 756.00 | | 5000-5999 | 5097,5044,5543,5474,5243 | | | | | | | 7 | 280 HFS | 31-Oct-23 | $ 11,914.00 | | 6000-6999 | 6069,6363,6229 | | | | | | | 8 | 386 HWK | 13-Feb-23 | $ 13,028.00 | | 7000-7999 | 7642 | | | | | | | 9 | 333 MZG | 19-Feb-23 | $ 12,946.00 | | 8000-8999 | 8253,8188,8169 | | | | | | | 10 | 345 ZVW | 12-Mar-23 | $ 14,295.00 | | 9000-9999 | 9804 | | | | | | | 11 | 370 NRC | 9-Nov-23 | $ 13,267.00 | | 10000-15000 | 14112,11914,13028,12946,14295,13267,14191,13624,12335,10286,13733,10425,13962,11964,12054 | | | | | | | 12 | 204 RRP | 17-Apr-23 | $ 936.00 | | | | | | | | | | 13 | 408 KBF | 2-Jul-23 | $ 14,191.00 | | | | | | | | | | 14 | 361 OYY | 12-Dec-23 | $ 5,097.00 | | | | | | | | | | 15 | 173 INA | 27-Aug-23 | $ 8,253.00 | | | | | | | | | | 16 | 133 VFC | 5-Aug-23 | $ 8,188.00 | | | Formula used in G 3 | | | | | | | 17 | 233 XBD | 9-Jul-23 | $ 2,131.00 | | | | | | | | | | 18 | 240 GLO | 25-May-23 | $ 8,169.00 | | | =TEXTJOIN(",",,IFERROR(LOOKUP(($D$3:$D$52>=LEFT(F3,1)+0)*($D$3:$D$52<=RIGHT(F3,LEN(F3)-FIND("-",F3))+0)*ROW($D$3:$D$52),ROW($D$3:$D$52),$D$3:$D$52),"")) | | | | | | | 19 | 433 OQI | 8-Nov-23 | $ 1,802.00 | | | | | | | | | | 20 | 355 CPF | 26-Apr-23 | $ 13,624.00 | | | | | | | | | | 21 | 271 OXZ | 15-May-23 | $ 3,973.00 | | | | | | | | | | 22 | 313 YGJ | 14-Jun-23 | $ 2,710.00 | | | | | | | | | | 23 | 288 HSK | 26-Oct-23 | $ 12,335.00 | | | | | | | | | | 24 | 387 EUE | 16-Dec-23 | $ 5,044.00 | | | | | | | | | | 25 | 446 QRC | 25-Jun-23 | $ 769.00 | | | | | | | | | | 26 | 143 LOR | 27-Nov-23 | $ 10,286.00 | | | | | | | | | | 27 | 446 AUC | 5-Feb-23 | $ 6,363.00 | | | | | | | | | | 28 | 314 EAV | 6-Mar-23 | $ 4,025.00 | | | | | | | | | | 29 | 273 NQX | 15-Jul-23 | $ 5,543.00 | | | | | | | | | | 30 | 239 FFR | 13-Oct-23 | $ 4,821.00 | | | | | | | | | | 31 | 338 YVD | 7-Jun-23 | $ 1,798.00 | | | | | | | | | | 32 | 149 XJC | 15-Dec-23 | $ 9,804.00 | | | | | | | | | | 33 | 316 VFL | 28-Jan-23 | $ 4,899.00 | | | | | | | | | | 34 | 260 GDS | 22-Feb-23 | $ 13,733.00 | | | | | | | | | | 35 | 280 BYW | 22-Jul-23 | $ 10,425.00 | | | | | | | | | | 36 | 451 WXX | 27-Aug-23 | $ 3,257.00 | | | | | | | | | | 37 | 421 TXB | 6-May-23 | $ 13,962.00 | | | | | | | | | | 38 | 384 MPP | 10-Nov-23 | $ 5,474.00 | | | | | | | | | | 39 | 431 EKK | 13-Jun-23 | $ 11,964.00 | | | | | | | | | | 40 | 377 UKT | 18-Jan-23 | $ 4,861.00 | | | | | | | | | | 41 | 228 MCD | 25-Feb-23 | $ 4,019.00 | | | | | | | | | | 42 | 259 TFS | 15-Oct-23 | $ 5,243.00 | | | | | | | | | | 43 | 184 WMM | 17-Sep-23 | $ 12,054.00 | | | | | | | | | | 44 | 123 RBJ | 17-Sep-23 | $ 742.00 | | | | | | | | | | 45 | 428 YPF | 11-Sep-23 | $ 1,452.00 | | | | | | | | | | 46 | 255 YUI | 18-Sep-23 | $ 4,955.00 | | | | | | | | | | 47 | 353 LNM | 9-Jul-23 | $ 6,229.00 | | | | | | | | | | 48 | 148 NLD | 13-Nov-23 | $ 4,562.00 | | | | | | | | | | 49 | 159 SNV | 13-Mar-23 | $ 7,642.00 | | | | | | | | | | 50 | 126 GPI | 26-Dec-23 | $ 3,364.00 | | | | | | | | | | | | | | | | | | | | | | | Total Sales | 344461.00 | | | | | | | | |
|
