Basic steps to check whether two columns of data are consistent in Excel

Take the following two columns of numbers as examples.

Select two columns of data and directly use the shortcut key CTL to quickly filter out different data in the two columns. This diagonal bar is the diagonal bar button above the enter key and below the backspace key, not the diagonal bar next to the period. After filtering out, fill the data with a color so that problematic data is clearly marked.

At that time, some users’ data was horizontal and this method was not suitable. What should I do?

It doesn’t matter, select the horizontal data to copy, click [Paste]-[Transpose] above the blank space to convert the data into a sequence, and then use that method Achieved.

The above is the detailed content of Basic steps to check whether two columns of data are consistent in Excel. For more information, please follow other related articles on the PHP Chinese website!