Forum Discussion

Joshua1764's avatar
Joshua1764
Copper Contributor
Jan 30, 2025

COMPARE DATE FROM DIFFERENT SHEETS

compare Table2 with Table1 data, highlight any difference in identification number for the same TT no in table1.

 

TABEL 1

TT NOIdentity number
KA19AB47341073
KA19AB4734T892
KA19AB4739T751
KA19AB4743811
KA19AB4743T750
KA19AB4793940
KA19AB4793T384
KA19AB4811T302
KA19AB4811T982
KA19AB4816T694
KA19AB4820T308
KA19AB4820T921
KA19AB4824T924
KA19AB4946998
KA19AB4955T834
KA19AB49641146
KA19AB4964T903
KA19AB4978T329
KA19AB4978T983
KA19AB4982T894
KA19AB4987T669
KA19AB4987T907
KA19AB4991T858
KA19AB4991T906
KA19AB5004T357
KA19AB5004T927
KA19AB5149T828
KA19AB5149T980
KA19AB51571076
KA19AB51571096
KA19AB5157T695
KA19AB5158T731
KA19AB5158T859
KA19AC5697T884
KA19AC5697T973
KA19AC9610T539
KA19AC9610T649
KA19AC9878687
KA19AC99501293
KA19AC9950T825
KA19AD0680T229
KA19AD0680T351
KA19AD06831029
KA19AD0684T535
KA19AD0684T601
KA19AD0685T382
KA19AD0685T885
KA19AD9887T295
KA19AD9887T398
KA19AE0976T481
KA19AE0976T824
KA19AE0977T981
KA19AE2182T309
KA19AE2182T417
KA19AE2183681
KA19AE2184T692
KA19AE2184T951
KA19AE2185T363
KA19AE2185T455
KA19AE2186T511
KA19AE2186T925
KA19AE2802T794
KA19AE2802T909
KA19AE2803T608
KA19AE2803T905
KA19AE28221189
KA19AE3463T580
KA19AE3463T833
KA19AE3464T241
KA19AE3464T746
KA19AE43581210
KA51AK5330810
KA51AK5330845
KA51AK5331T749
KA51AK5333T547
KA51AK5333T628
KA51AK5334T713
KA51AK5334T950
KA51AK6029T592
KA51AK6029T940
KA51AK6030T353
KA51AK6030T922
KA51AK6031T219
KA51AK6031T898
KA51AK6032T440
KA51AK60331091
KA51AK6033T756
KA01AE2699T764
KA01AE2699T896
KA01AE3469T651
KA01AE3469T658
KA01AE4679T590
KA01AE5699T450
KA01AE5699T937
KA01AE6689T659
KA01AG5689T564
KA01AG5689T600
KA01AG5899T631
KA01AG5899T734
KA01AM1489449
KA01AQ5799T566
KA01AQ5799T681
KA01AQ5899T595
KA01AQ6799T483
KA01AQ6799T631
KA01AQ7899T459
KA01AQ7899T598
KA01AQ8599T518
KA01AQ8599T935
KA02AE5227T633
KA05AF2899T503
KA05AF2899T821
KA05AF2999T645
KA51AA3599T680
KA51C2499T593
KA51C2499T803
KA51C3899T554
KA51C4799T788
KA51C5799T779
KA51C6689T648
KA51C7779T638
KA51C7779T870
KA51C8889T969
KA51D6899T594
KA51D6899T954
KA51D6999T881
KA702339T484
KA702339T934
KA702689T661
KA702689T662
TN30BD6899T482
KA01AG6609T931
KA01AG8809T683
KA01AG8809T684
KA01AG9029T542
KA01AG9079T843
KA01AH4009T579
KA01AH7309T421
KA01AH7309T577
KA01AH7409T939
KA01AH9049T508
KA01AH9049T723
KA01AH9609T801
KA01AH9609T942
KA01AJ7809T789
KA01AJ7809T790
KA01AJ7909882
KA01AL3609T433
KA01AL37091061
KA01AL3709T842
KA01AL3939T987
KA01AL4609T814
KA01AL4609T966
KA01AL4709938
KA01AL4709T504
KA01AL7589428
KA01AL7599T430
KA01AL7599T919
KA01AL7989252
KA01AL7989T616
KA01AM4090T544
KA01AM4090T900
KA01AM4099T443
KA01AM4099T985
KA01AP0290T360
KA01AP0290T930
KA51AF6874587
KA51AF6874T975
KA51AF6875T701
KA51AF6875T986
KA51AF6876T460
KA51AF6876T724
KA51AF6878T315
KA51AF6878T561
KA51AF6879T654
KA51AF6879T918
KA51AF6882T316
KA51AF6882T367
KA51AF68831304
KA51AF6883T943
TN28BK82081025
TN28BK8208T974
TN28BK8237505
TN28BK8237T745
TN28BK8291T572
GJ10TV5778T831
GJ10TV7956741
GJ10TV7956984
KA01AF8494T515
KA01AF8494T976
KA01AF8496664
KA01AF8496T810
KA01AF8557661
KA01AF8557662
KA01AF8559654
KA01AF8559806
KA01AF869441145
KA01AF8694T963
KA01AF87391182
KA01AF8748T809
KA01AF8748T958
KA01AF8757T599
KA01AF87751014
KA01AF8775T822
KA07B9197T889
KA07B9198T904
KA07B9198T932
KA07B92001099
KA07B9200T532
KA07B9201676
KA07B9201T507
KA07B9202T912
KA07B9202T959
KA07C0070T913
KA07C0071T917
KA07C0072T944
KA07C0072T948
KA07C0073T531
KA07C0074667
KA07C0075T914
AP39UF24411150
AP39UF2441T807
KA01AG0407T817
KA01AG1082T891
KA01AG1082T984
KA01AG40201021
KA01AL1483T359
KA01AL1483T715
KA01AN5253T492
KA01AN525446476
KA01AN5254T614
KA01AN6409T630
KA01AN6409T879
KA01AN6410459
KA01AN6410692
KA01AN6411T799
KA01AN6411T977
KA01AN6412T747
TN33BJ9570T771
TN33BJ9570T772
TN33BK6629T773
TN33BK6629T774
TN33BL4316T725
TN33BL4316T941
TN33BL6043T378
TN33BL6043T477
TN33BL83901017
TN33BL8390T965
TN33BM1287T415
TN33BM1287T887
TN33BP1136T451
TN56K08911020
TN56K0891T971
TN30BD6899T882
TN30BD7689T665
TN30BD7689T787
TN30BD7899T559

 

TABEL 2

TT NOIdentity numberIdentity number
KA51C2499T593T803
KA01AE3469T633T936
KA01AQ8599T518T935
KA51AF6879T654T918
KA01AG8809T684T683
KA51AF6878T561T315
KA01AL7989T616252
KA01AH7309T577T421
KA19AB49641146T903
KA19AE2802T794T909
KA02AE5227T633T936
KA19AE2803T608T905
AP39UF2441T8071150
KA19AB51571076T695
KA19AB5004T3571076
KA01AF8496T810664
TN33BL83901017T965
KA51AF6882T367T316
KA19AD0680T351T229
GJ10TV5778679T831
KA01AH4009T579T435
KA01AF8757T599T911
KA19AB4955T834T886
KA51AF6875T701T986
KA01AJ79098821290
KA51AK5334T713T950
KA51AK6032T441T440
KA51C4799T946T955
TN28BK8291T699T572
KA51AK60331091T756
KA19AE43581210T867
KA19AB4946998T624
KA19AE28221189T533
TN33BK6629T774T773
KA19AB4982T627T894
KA01AL3609376T433
TN28BK8237T745505
KA07C00751225T914
KA51AK6031T219T898
KA01AL7589428T945
KA51C3899T705T554
KA01AF87391182T910
KA51AA3599T776T680
KA01AN6410692459
TN30BD7689T665T787
KA51D6999T881T556
KA01AN5253T492T968
GJ10TV7956741984
KA19AC5697T884T973
KA01AE6689T659T596
KA01AG9079T509T843
KA19AE2184T692T951
KA07C0073T531T962
KA19AC9878687T695
KA01AL1483T715T359
KA07C0074667T915
KA19AD06831029T920
KA01AQ5899T595T776
KA51C5799T779T735
  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    Your question is not clear enough. What you want to do? Can you show your desired outcome?

    • Joshua1764's avatar
      Joshua1764
      Copper Contributor

       

      In table 2 TT no KA01AE3469 has identification number T633 T936 but in table 1 it has different identification number; it should highlight if it has difference value.

Resources