Spreadsheet: 837930d1690530296-how-to-add-the-correct-number-in-column-a-problem
Sheet: Expected result

 |  | Boekingsdatum | Doc.Nr.
 |  | L00929
 | L00929 | 30/11/18 | AF18190206
 | L00929 | 23/02/23 | ING/22-175-02
 | L00929 | 31/12/18 | AF18190248
 | [NAME] | 31/01/19 | AF18190313
 | L00931 | 28/02/19 | AF18190352
 | L00932 | 31/03/19 | AF18190405
 | L00933 | 30/04/19 | AF18190454
 | L00934 | 31/05/19 | AF18190499
 | L00935 | 30/06/19 | AF18190514
 | L00936 | 30/06/19 | AF18190515
 | L00937 | 31/07/19 | AF19200020
 | L00938 | 31/08/19 | AF19200052
 | L00939 | 30/09/19 | AF19200115
 | L00940 | 31/10/19 | AF19200158
 | [NAME] | 30/11/19 | AF19200210
 | L00942 | 31/12/19 | AF19200264
 | [NAME] | 31/01/20 | AF19200307
 | L00944 | 29/02/20 | AF19200363
 | L00945 | 31/03/20 | AF19200396
 | [NAME] | 30/04/20 | AF19200408
 | L00947 | 31/05/20 | AF19200439
 | L00948 | 30/06/20 | AF19200473
 | L00949 | 31/07/20 | AF20210047
 | [NAME] | 31/08/20 | AF20210103
 | L00951 | 30/09/20 | AF20210137
 | [NAME] | 31/10/20 | AF20210181
 | L00953 | 30/11/20 | AF20210281
 | L00954 | 31/12/20 | AF20210339
 | L00955 | 31/01/21 | AF20210383
 | L00956 | 28/02/21 | AF20210471
 | L00957 | 31/03/21 | AF20210597
 | L00958 | 30/04/21 | AF20210679
 | L00959 | 31/05/21 | AF20210753
 | L00960 | 30/06/21 | AF20210842
 | L00961 | 31/07/21 | AF21220075
 | L00962 | 31/08/21 | AF21220129
 | L00963 | 30/09/21 | AF21220217
 | L00964 | 06/04/23 | ING/22-206-05
 | L00965 | 09/05/23 | ING/22-229-04
 | L00966
 | L00967
 | L00968
 | L00969
 | [NAME]
 | L00971
 | L01177 | L01177
 | [NAME]
 | L01179
 | L01180 | 03/02/22 | ING/21-156-03
 | L01181 | 09/05/22 | BEL/21-095-01
 | L01182 | 27/07/22 | ING/22-020-02
 | L01183 | 28/10/22 | ING/22-090-07
 | L01184 | 03/03/23 | ING/22-181-08
 | L01185 | 16/03/23 | ING/22-190-01
 | L01186 | 26/04/23 | BEL/22-076-02
 | L01187
 | [NAME]
 | L01189
 | L01190
 | L01191
 | L01192
 | L01025 | L01025
 | L01026
 | L01027
 | L01028 | 02/06/23 | AF22230631
 | L01029 | 09/06/23 | AF22230645
 | [NAME] | 23/06/23 | AF22230657
 | L01031 | 30/06/23 | AF22230680
 | L01032
 | L01033
 | L01034
 | L01035
 | L01036
 | L01037
 | L01219 | L01219
 | L01220
 | [NAME]
 | L01222 | 31/05/23 | AF22230625
 | L01223
 | L01224
 | L01225
 | L01226
 | L01227
 | L01228
 |  | L01068
 |  | 12/06/23 | AF22230652
 |  | 26/06/23 | AF22230679
 |  | [NAME]
 |  | 21/04/23 | AF22230547
 |  | 01/05/23 | D22230104
 |  | 31/05/23 | ING/22-245-05
 |  | 31/05/23 | AF22230613
 |  | 30/06/23 | BEL/22-097-02
 |  | 30/06/23 | AF22230682
 |  | 30/06/23 | AF22230683
 |  | 30/06/23 | AF22230684
 |  | 30/06/23 | AF22230685
 |  | 30/06/23 | AF22230686
 |  | 09/06/23 | AF22230688
 |  | 16/06/23 | AF22230689
 |  | 23/06/23 | AF22230690
 |  | 30/06/23 | AF22230691
 |  | 30/06/23 | AF22230692
 |  | 30/06/23 | AF22230694
 |  | L01069
 |  | 31/05/23 | AF22230636
 |  | L01154
 |  | 01/05/23 | AF22230632
 |  | L01117
 |  | 23/12/22 | AF22230360
 |  | 23/12/22 | AF22230361
 |  | 30/12/22 | AF22230372
 |  | 30/12/22 | AF22230373
 |  | 30/12/22 | AF22230374
 |  | 30/12/22 | AF22230400
 |  | 20/01/23 | AF22230405
 |  | 31/01/23 | AF22230424
 |  | 31/01/23 | AF22230425
 |  | 31/01/23 | AF22230426
 |  | 28/02/23 | AF22230466
 |  | 28/02/23 | AF22230467
 |  | 28/02/23 | AF22230468
 |  | 31/03/23 | AF22230527
 |  | 31/03/23 | AF22230528
 |  | 31/03/23 | AF22230529
 |  | 31/05/23 | AF22230627
 |  | 31/05/23 | AF22230628
 |  | L01209
 |  | 24/01/23 | AF22230408
 |  | 09/03/23 | AC2223004
 |  | L01198
 |  | 03/05/23 | ING/22-225-07
 |  | 04/05/23 | AF22230568
 |  | 06/06/23 | ING/22-249-07
 |  | 07/06/23 | AF22230647
 |  | 30/06/23 | AF22230664
 |  | L01028
 |  | 30/06/23 | AF22230676
 |  | L01040
 |  | 20/06/23 | AF22230651
 |  | 06/06/23 | AF22230695
 |  | L01134
 |  | 15/06/23 | AF22230653
 |  | L01183
 |  | 23/06/23 | AF22230656
 |  | 27/06/23 | AF22230658
 |  | 30/06/23 | AF22230668
 |  | 30/06/23 | AF22230669
 |  | 30/06/23 | AF22230670
 |  | 30/06/23 | AF22230671
 |  | 30/06/23 | AF22230672
 |  | 30/06/23 | AF22230673
 |  | 30/06/23 | AF22230674
 |  | [NAME]
 |  | 28/06/23 | AF22230654
 |  | L00427
 |  | 30/06/23 | AF22230662
 |  | [NAME]
 |  | 30/04/23 | AF22230555
 |  | 31/05/23 | AF22230586
 |  | 30/06/23 | AF22230663
 |  | L01084
 |  | 29/06/23 | AF22230666
 |  | 29/06/23 | AF22230667
 |  | L01103
 |  | 30/06/23 | AF22230681
 |  | L00797
 |  | 22/06/23 | AF22230649
 |  | 23/06/23 | AF22230650
 |  | L01048
 |  | 12/06/23 | AF22230639
 |  | 12/06/23 | AF22230640
 |  | 28/06/23 | AF22230659
 |  | L01076
 |  | 23/06/23 | AF22230655
 |  | L01093
 |  | 01/06/23 | AF22230677
 |  | 30/06/23 | AF22230678
 |  | [NAME]
 |  | 28/06/23 | AF22230665
 |  | [NAME]
 |  | 31/10/22 | AF22230281
 |  | 30/11/22 | AF22230325
 |  | 30/12/22 | AF22230386
 |  | 31/01/23 | AF22230412
 |  | 28/02/23 | AF22230443
 |  | 31/03/23 | AF22230526
 |  | 28/04/23 | AF22230543
 |  | 19/05/23 | ING/22-237-02
 |  | 31/05/23 | AF22230605
 |  | 02/06/23 | ING/22-247-06
 |  | 08/06/23 | ING/22-251-09
 |  | 19/06/23 | ING/22-258-07
 |  | 20/06/23 | ING/22-259-02
 |  | 30/06/23 | AF22230693
 |  | L01053
 |  | 31/05/23 | AF22230630
 |  | 30/06/23 | AF22230675
 |  | L00378
 |  | 01/06/23 | AF22230646
 |  | L00980
 |  | 04/06/23 | AF22230635
 |  | 11/06/23 | AF22230638
 |  | 17/06/23 | AF22230660
 |  | 25/06/23 | AF22230661