00:00Listen, if you are worried that your two data set might be different, just remember, there are two ways to
00:04determine that.
00:05Let's start off by duplicating our existing worksheet.
00:08By the way, here's a challenge for you.
00:09Do you know what the Excel hotkey is to add a brand new worksheet like this?
00:14Leave the answer in the comment section if you do.
00:16After that, copy and paste the data set from worksheet 421 to the brand new worksheet.
00:21Now, the first method is to use conditional formatting.
00:24Place your cursor somewhere on your data set and press Ctrl A.
00:27And then after that, from your ribbon, you're going to go Home Style Conditional Formatting New Rule.
00:32Use a formula and basically compare cell values in A1 between the two data set.
00:37After that, click on the Format button and then make sure you're on the Fill tab and select the Fill
00:42color to be red and press OK twice.
00:45Now, if you make any changes in any of the data set table here, you can see the deviation is
00:50highlighted.
00:51Now for the second method.
00:52In this second method, which is a bit crude, but if you're looking to get a quick answer, if the
00:56two data sets are different, you need to use a concatenate function.
00:59Place your cursor on cell F1 on a brand new worksheet and basically concatenate all the data set value to
01:05a single cell like this.
01:06After that, select cell F1 on your sheet 421 and do the same formula.
01:12And after that, on the same worksheet 421, go to cell F2 and then compare the output from the two
01:18concatenate function like this.
01:20If there is any difference between the two data set value, this conditional formula will return false.
01:26And if they're exactly the same, it will return true.
01:28And if they're exactly the same, it will return true.
Comments