RE: Comparing data

Dear Paul

Thank you for attending Excel 2007 Introduction course!! I hope you enjoyed the course and benefited from it.

To compare more than one workbook make sure that all the workbooks that you wish to compare are open. Also please ensure that you close any unnecessary workbooks.

On the Ribbon click on the View Tab

Choose Arrange All from the Window group.

From the dialog box choose if you want the workbook windows to be arranged Tiled, Horizontal, Vertical or Cascade.

In order to take out any duplicates the quickest and easiest way will be to format your range as a table.

This feature is something that we cover in our Excel 2007 Intermediate course.

I'll give you a step by step instruction to remove duplicates:

Click anywhere inside the range of data that you have. Please ensure that teh first row has teh column headongs and also that there are no extra blank rows or columns in your range.

On the Ribbon choose Home Tab

Choose Format as Table from the Styles group

When you get teh Format As Table dialog box simply press OK.

You will see a Table Tools contextualized tab on the ribbon.

Choose design sub tab and then click on the option called "remove duplicate"

When it asks you which column contains duplicate values depending on the columns either select the individual columns or simply leave the default as Select all if you wish to remove entire record/s.

Press OK and you will get a message about how many records were deleted.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007