What happens next?

How to compare data in excel
Highlight the first cell of a blank column.
When comparing two columns in a worksheet, you'll be outputting your results onto a blank column. Make sure you are starting on the same row as the two columns you're comparing.

Choose from: +For example, if the two columns you want to compare start on a2 and b2, highlight c2. Type the comparison formula for the first row. +If you want to compare between two columns, set the starting cell to " fill " instead of "-all. " by selecting " fill " you can list your numbers in a row instead of both, for example : 1. +If you don't have a blank column in your worksheet, you can go online and look at other, similar cells in the worksheet. Be sure your column contains both separated data and selected values for words or formulas that can be used together to find data. +Highlight the figure and make your data columns even. Always highlight the figure and make sure the numbers in the row you're comparing are equally spaced in relation to each other.
For example, if the two columns you want to compare start on a2 and b2, highlight c2. Type the comparison formula for the first row.