Spreadsheet: 770850d1646301409-merging-data-for-match-cases-only-matching-merge
Sheet: Results

Date | MYID | Case | Result | Comment | Rate
2021-11-13 00:00:00 | 966160 | Case2 | 11.7575 |  |  | 1. If C2 is Case1 and D2 is between 7.25 and 10.15, then result in comment (E2) is "PASS"
2021-11-14 00:00:00 | 962811 | Case1 | 24.06 |  |  | 2. If C2 is Case2 and [NAME] is between 3.05 and 6.15, then result in comment (E2) is "PASS"
2021-11-15 00:00:00 | 963103 | Case1 | 57.67 |  |  | 3. If C2 is Case1 and Rate (B:B) of worksheeet 'Demo' for matching case of MYID (A:A) is <6, then result in comment (E2) is "RECHECK"
2021-11-16 00:00:00 | 966764 | Case2 | 7.6475 |  |  | 4. If C2 is Case2 and Rate (B:B) of worksheeet 'Demo' for matching case of MYID (A:A) is between 4.25 and 5.99, then result in comment (E2) is "RECHECK"
2021-11-17 00:00:00 | 968114 | Case1 | 6.7475
2021-11-18 00:00:00 | 962744 | Case2 | 11.285 |  |  | Also: How to import value for Rate from Demo worksheet into [NAME] for matching case only
2021-11-19 00:00:00 | 963019 | Case2 | 8.9825
2021-11-20 00:00:00 | 962654 | Case1 | 13.36
2021-11-21 00:00:00 | 967998 | Case2 | 10.1
2021-11-22 00:00:00 | 962839 | Case1 | 14.34
2021-11-23 00:00:00 | 968105 | Case2 | 8.5875
2021-11-24 00:00:00 | 967520 | Case1 | 7.56
2021-11-25 00:00:00 | 963084 | Case2 | 10.4675
2021-11-26 00:00:00 | 962900 | Case1 | 51.42
2021-11-27 00:00:00 | 964927 | Case1 | 66.51
2021-11-28 00:00:00 | 968116 | Case1 | 46.28
2021-11-29 00:00:00 | 962300 | Case1 | 66.01
2021-11-30 00:00:00 | 962359 | Case1 | 54.61
2021-12-01 00:00:00 | 967519 | Case1 | 69.91
2021-12-02 00:00:00 | 965938 | Case2 | 13.89
2021-12-03 00:00:00 | 964914 | Case1 | 52.57
2021-12-04 00:00:00 | 962728 | Case1 | 54.25
2021-12-05 00:00:00 | 964915 | Case1 | 54.02
2021-12-06 00:00:00 | 962685 | Case1 | 38.72
2021-12-07 00:00:00 | 962310 | Case1 | 53.07
2021-12-08 00:00:00 | 966069 | Case1 | 31.655
2021-12-09 00:00:00 | 963869 | Case1 | 67.62
2021-12-10 00:00:00 | 966836 | Case2 | 27.14
2021-12-11 00:00:00 | 963638 | Case2 | 6.6425
2021-12-12 00:00:00 | 967024 | Case1 | 7.925000000000001
2021-12-13 00:00:00 | 962741 | Case2 | 9.4725
2021-12-14 00:00:00 | 964380 | Case2 | 9.7225
2021-12-15 00:00:00 | 963858 | Case1 | 74.11
2021-12-16 00:00:00 | 962665 | Case2 | 9.5525
2021-12-17 00:00:00 | 965901 | Case2 | 9.135
2021-12-18 00:00:00 | 966861 | Case1 | 40.76
2021-12-19 00:00:00 | 963122 | Case2 | 7.2075
2021-12-20 00:00:00 | 962355 | Case1 | 2.1125
2021-12-21 00:00:00 | 966993 | Case1 | 53.38
2021-12-22 00:00:00 | 962699 | Case1 | 3.89
2021-12-23 00:00:00 | 968134 | Case2 | 4.3275
2021-12-24 00:00:00 | 962366 | Case1 | 23.3
2021-12-25 00:00:00 | 967523 | Case1 | 22.06
2021-12-26 00:00:00 | 962780 | Case1 | 26.21
2021-12-27 00:00:00 | 965916 | Case1 | 30.79
2021-12-28 00:00:00 | 968129 | Case1 | 2.8575
2021-12-29 00:00:00 | 964424 | Case2 | 10.14
2021-12-30 00:00:00 | 964476 | Case1 | 18.33
2021-12-31 00:00:00 | 967482 | Case1 | 43.185
2022-01-01 00:00:00 | 963108 | Case2 | 8.8525
2022-01-02 00:00:00 | 963109 | Case1 | 58.21
2022-01-03 00:00:00 | 967509 | Case1 | 67.55
2022-01-04 00:00:00 | 966999 | Case2 | 8.9325
2022-01-05 00:00:00 | 964860 | Case1 | 2.46
2022-01-06 00:00:00 | 962758 | Case2 | 11.2575
2022-01-07 00:00:00 | 967930 | Case2 | 25.26
2022-01-08 00:00:00 | 963853 | Case1 | 54.245
2022-01-09 00:00:00 | 963873 | Case2 | 6.773333333333333
2022-01-10 00:00:00 | 967944 | Case1 | 51.0575
2022-01-11 00:00:00 | 967838 | Case2 | 9.325
2022-01-12 00:00:00 | 964905 | Case1 | 52.35
2022-01-13 00:00:00 | 967950 | Case1 | 82.1
2022-01-14 00:00:00 | 963078 | Case1 | 53.05
2022-01-15 00:00:00 | 962822 | Case1 | 70.22
2022-01-16 00:00:00 | 967547 | Case1 | 57.87
2022-01-17 00:00:00 | 968081 | Case1 | 3.972499999999999
2022-01-18 00:00:00 | 965913 | Case2 | 8.030000000000001
2022-01-19 00:00:00 | 964870 | Case2 | 6.9125
2022-01-20 00:00:00 | 964425 | Case2 | 8.4375
2022-01-21 00:00:00 | 968000 | Case1 | 44.11
2022-01-22 00:00:00 | 962754 | Case2 | 11.3575
2022-01-23 00:00:00 | 965935 | Case2 | 9.727500000000001
2022-01-24 00:00:00 | 963842 | Case1 | 57.73
2022-01-25 00:00:00 | 965978 | Case2 | 7.8
2022-01-26 00:00:00 | 962810 | Case2 | 6.39
2022-01-27 00:00:00 | 967962 | Case1 | 5.7125
2022-01-28 00:00:00 | 966098 | Case1 | 40.07
2022-01-29 00:00:00 | 964873 | Case2 | 10.2975
2022-01-30 00:00:00 | 967827 | Case2 | 7.8575
2022-01-31 00:00:00 | 963613 | Case2 | 10.28
2022-02-01 00:00:00 | 963100 | Case2 | 10.5625
2022-02-02 00:00:00 | 964903 | Case2 | 7.062499999999999