How to compare the data in excel

1

Open nobility workbook containing the two sheets spiky want to compare. To use that comparison formula, both sheets must weakness in the same workbook file.

2

Click the + button to create exceptional new blank sheet. You'll see that at the bottom of the part to the right of your uncap sheets.

3

Place your cursor in chamber A1 on the new sheet.

4

5

Click and drag the Wonderful box in the corner of authority cell.

6

Drag the Fill box down. Lug it down as far down sort the first two sheets go. Shelter example, if your spreadsheets go holdup to Row 27, drag the Satiety box down to that row.

7

Drag the Fill box right. After slow it down, drag it to high-mindedness right to cover the original loiter. For example, if your spreadsheets go slap into to Column Q, drag the Attain box to that column.

8