If you are trying to compare data between 2 columns and want to identify the differences, there is a simple way to do that in Excel. Comparison of data between columns can be quite handy for various reasons, including reconciliation of information and identifying different values.
Step 1: Select the columns you want to compare
Step 2: From Home Tab, click on Conditional Formatting > Highlight Cell Rules > Duplicate Values
Step 3: Select either Duplicate or Unique values from the dropdown.
Duplicate values will highlight values which are the same between the two columns while unique values will highlight data which is different between the two columns.
If you are experiencing issues with your Windows system due to the Crowdstrike update, here's…
Koodo customers in Canada can now get Amazon Prime, Netflix Standard with ads and Disney+…
If you received an email with a single use code to login to your Microsoft…
If you are trying to login to your Microsoft account and getting the following error…
Most system admins set Microsoft Teams status to show Away when you are inactive for…
If you are using a Windows computer and your keyboard doesn't have a backslash "\"…
