Have you ever had to find the cell whose value did not match those of other cells in the same row?
Rather than checking manually, Excel
Row Differences allows you to quickly find cells in rows that are different than the others. This function is especially useful in large workbooks with many different sets of data.
Find different values in a row
Perform the following steps to use the
Row Differences functionality.
1. Highlight the range of cells of which the data has to be processed. Note that we are not including the cells from column A since those cells have information that does not need to be compared.
2. Select the
Find & Select option on the far-right of the
Home tab and click on
Go To Special.
3. Select the
Row Differences option in the
Go To Special dialog box and click OK.
You will be redirected to your workbook and the cells whose values are different from those in the same row will be selected.
4. Change the background color of the selected cells by going to the
Home tab and selecting the
Fill Color option in the
Font section of the ribbon.
All cells with the same value as other cells in the same row will now be highlighted with the color you selected.
Find different values in columns
Of course, you can do the same for finding differences in columns. To do that, follow the same steps as above, but in step 3 instead of choosing Row differences, now choose
Again, you then select all the values that are different in the column and you can give them another background color for example.
If you have any questions about this, feel free to let me know in the comments. I’m happy to help!