Spreadsheet: 774015d1648160933-merging-formula-not-working-merging-formula-not-working
Sheet: Sheet2

MYID | Case | Result | DA | GA | Comment |  | CaseA Only | CaseB Only
1XX542143440 | CaseA | 11.7575 | 646 | 32
1XX552145008 | [NAME] | 24.06 | 2 | 23
1XX562145241 | [NAME] | 57.67 | 0 | 24
1XX572145321 | CaseA | 7.6475 | 0 | 24
1XX582152521 | [NAME] | 6.7475 | 41 | 32
1XX592152521 | CaseA | 11.285 | 24 | 36
1XX602152540 | CaseA | 8.9825 | 1016 | 37
1XX612152619 | [NAME] | 13.36 | 36 | 27
1XX622153168 | CaseA | 10.1 | 24 | 39
1XX632153326 | [NAME] | 14.34 | 1112 | 34
1XX642161871 | CaseA | 8.5875 | 24 | 39
1XX652167990 | [NAME] | 7.56 | 27 | 37
1XX662168402 | CaseA | 10.4675 | 24 | 38
1XX672169979 | [NAME] | 51.42 | 24 | 39
1XX682170282 | [NAME] | 66.51 | 24 | 38
1XX692170348 | [NAME] | 46.28 | 24 | 37
1XX702171186 | [NAME] | 66.01 | 26 | 38
1XX712174722 | [NAME] | 54.61 | 24 | 39
1XX722174910 | [NAME] | 69.91 | 272 | 39
1XX732174962 | CaseA | 13.89 | 0 | 39
1XX742178089 | [NAME] | 52.57 | 320 | 40
1XX752178325 | [NAME] | 54.25 | 24 | 39
1XX762179043 | [NAME] | 54.02 | 272 | 35
1XX772179160 | [NAME] | 38.72 | 49 | 35
1XX782179191 | [NAME] | 53.07 | 30 | 40
1XX792179275 | [NAME] | 31.655 | 35 | 38
1XX802182716 | [NAME] | 67.62 | 28 | 39
1XX812182730 | CaseA | 27.14 | 33 | 39
1XX822182737 | CaseA | 6.6425 | 28 | 37
1XX832183797 | [NAME] | 7.925000000000001 | 28 | 37
1XX842183797 | CaseA | 9.4725 | 28 | 39
2XX092188849 | CaseA | 9.7225 | 28 | 38
2XX102188861 | [NAME] | 74.11 | 28 | 38
2XX112196312 | CaseA | 9.5525 | 199 | 36
2XX122196350 | CaseA | 9.135 | 473 | 37
2XX132196403 | [NAME] | 40.76 | 25 | 40
2XX142196421 | CaseA | 7.2075 | 26 | 39
2XX152196500 | [NAME] | 2.1125 | 40 | 36
2XX162184175 | [NAME] | 53.38 | 37 | 39
2XX172196712 | [NAME] | 3.89 | 32 | 39
2XX182196712 | CaseA | 4.3275 | 25 | 39
2XX192196553 | [NAME] | 23.3 | 25 | 37
2XX202201667 | [NAME] | 22.06 | 29 | 41
2XX212204441 | [NAME] | 26.21 | 25 | 39
2XX222204455 | [NAME] | 30.79 | 24 | 39
2XX232205439 | [NAME] | 2.8575 | 24 | 39
2XX242205618 | CaseA | 10.14 | 36 | 39
2XX252201728 | [NAME] | 18.33 | 25 | 40
2XX262197237 | [NAME] | 43.185 | 27 | 39
2XX272207274 | CaseA | 8.8525 | 0 | 38
2XX282208024 | [NAME] | 58.21 | 46 | 38
2XX292208131 | [NAME] | 67.55 | 27 | 37
2XX302208205 | CaseA | 8.9325 | 36 | 36
2XX312209978 | [NAME] | 2.46 | 646 | 32
2XX322210681 | CaseA | 11.2575 | 2 | 23
2XX332210798 | CaseA | 25.26 | 0 | 24
2XX342210805 | [NAME] | 54.245 | 0 | 24
2XX352210989 | CaseA | 6.773333333333333 | 41 | 32
2XX362210666 | [NAME] | 51.0575 | 24 | 36
2XX372213526 | CaseA | 9.325 | 1016 | 37
2XX382213550 | [NAME] | 52.35 | 36 | 27
2XX392213556 | [NAME] | 82.1 | 24 | 39
2XX402213588 | [NAME] | 53.05 | 1112 | 34
2XX412213886 | [NAME] | 70.22 | 24 | 39
2XX422216006 | [NAME] | 57.87 | 27 | 37
2XX432217889 | [NAME] | 3.972499999999999 | 24 | 38
2XX442217889 | CaseA | 8.030000000000001 | 24 | 39
2XX452210864 | CaseA | 6.9125 | 24 | 38
2XX462218235 | CaseA | 8.4375 | 24 | 37
2XX472218263 | [NAME] | 44.11 | 26 | 38
2XX482219827 | CaseA | 11.3575 | 24 | 39
2XX492220086 | CaseA | 9.727500000000001 | 272 | 39
2XX502220254 | [NAME] | 57.73 | 0 | 39
2XX512221709 | CaseA | 7.8 | 320 | 40
2XX522221731 | CaseA | 6.39 | 24 | 39
2XX532222248 | [NAME] | 5.7125 | 272 | 35
2XX542222316 | [NAME] | 40.07 | 49 | 35
2XX552219884 | CaseA | 10.2975 | 30 | 40
2XX562222388 | CaseA | 7.8575 | 35 | 38
2XX572224170 | CaseA | 10.28 | 28 | 39
2XX582224181 | CaseA | 10.5625 | 33 | 39
2XX592224352 | CaseA | 7.062499999999999 | 28 | 37
2XX602225952 | CaseA | 8.64 | 28 | 37
2XX612226178 | [NAME] | 2.735 | 28 | 39
2XX622226178 | CaseA | 7.6 | 28 | 38
2XX632226195 | CaseA | 8.7275 | 28 | 38
2XX642226196 | [NAME] | 62.27 | 199 | 36
2XX652226214 | [NAME] | 65.26 | 473 | 37
2XX662227830 | [NAME] | 62.19 | 25 | 40
2XX672227851 | CaseA | 9.252500000000001 | 26 | 39
2XX682227858 | CaseA | 8.98 | 40 | 36
2XX692227876 | CaseA | 7.725 | 37 | 39
2XX702227969 | [NAME] | 104.14 | 32 | 39
2XX712227985 | [NAME] | 64.26 | 25 | 39
2XX722227102 | [NAME] | 53 | 25 | 37
2XX732228275 | CaseA | 7.037500000000001 | 29 | 41
2XX742228437 | [NAME] | 57.55 | 25 | 39
2XX752228443 | [NAME] | 5.605 | 24 | 39
2XX762228443 | CaseA | 10.2625 | 24 | 39
2XX772228631 | [NAME] | 107.94 | 36 | 39
2XX782228645 | CaseA | 7.112500000000001 | 25 | 40
2XX792229597 | CaseA | 7.74 | 27 | 39
2XX802239913 | CaseA | 9.947500000000002 | 0 | 38
2XX812239918 | [NAME] | 5.615 | 46 | 38
2XX822239909 | CaseA | 7.535 | 27 | 37