Data 1 consists of columns Alpha, Beta, Delta. Similarly, Data 2 also consists of Columns Alpha, Beta, Delta. For both Data 1 and Data 2, Record simply denotes entry numbers. We need to know how many, if any, entries differ between Data 1 and Data 2. E.g., For each Record, does Alpha in Data 1 = Alpha in Data 2. Same for Beta and Delta. Construct a formula to count the number of entries that differ between Data 1 and Data 2. Number of entries that differ between Data 1 and Data 2 Use conditional formatting to highlight in red any entry in Data 2 that differs from Data 1. Data 1 Data 2 Record Beta Alpha 112 Delta 945 Delta 945 1 Beta 498 856 958 Alpha 112 482 498 Record 1 2 3 2 361 2 482 952 2 2 361 856 958 3 100 952 555 4 944 705 939 4 944 705 939 739 813 5 813 5 6 592 882 967 739 964 964 314 6 592 882 967 314 7 181 182 7 181 182 315 737 8 389 222 737 000 389 250 772 900 9 250 772 900 360 164 10 844 164 11 115 844 549 548 395 360 849 516 492 11 12 13 12 Co w 6 849 516 492 109 783 577 137 549 548 395 707 115 114 831 896 235 853 814 14 15 16 17 MEDIAN(number1, [number2], ...) 14 374 114 831 896 235 853 707 374 759 295 548 662 109 783 577 137 211 15 16 17 18 19 814 759 295 548 662 595 595 211 250 742 250 742 19 20 21 826 354 20 416 826 354 416 511 897 110 21 511 897 110 Data 1 consists of columns Alpha, Beta, Delta. Similarly, Data 2 also consists of Columns Alpha, Beta, Delta. For both Data 1 and Data 2, Record simply denotes entry numbers. We need to know how many, if any, entries differ between Data 1 and Data 2. E.g., For each Record, does Alpha in Data 1 = Alpha in Data 2. Same for Beta and Delta. Construct a formula to count the number of entries that differ between Data 1 and Data 2. Number of entries that differ between Data 1 and Data 2 Use conditional formatting to highlight in red any entry in Data 2 that differs from Data 1. Data 1 Data 2 Record Beta Alpha 112 Delta 945 Delta 945 1 Beta 498 856 958 Alpha 112 482 498 Record 1 2 3 2 361 2 482 952 2 2 361 856 958 3 100 952 555 4 944 705 939 4 944 705 939 739 813 5 813 5 6 592 882 967 739 964 964 314 6 592 882 967 314 7 181 182 7 181 182 315 737 8 389 222 737 000 389 250 772 900 9 250 772 900 360 164 10 844 164 11 115 844 549 548 395 360 849 516 492 11 12 13 12 Co w 6 849 516 492 109 783 577 137 549 548 395 707 115 114 831 896 235 853 814 14 15 16 17 MEDIAN(number1, [number2], ...) 14 374 114 831 896 235 853 707 374 759 295 548 662 109 783 577 137 211 15 16 17 18 19 814 759 295 548 662 595 595 211 250 742 250 742 19 20 21 826 354 20 416 826 354 416 511 897 110 21 511 897 110
