Data Comparing

Resolved · Medium Priority · Version 2003

Tue 23 Sep 2008, 11:36 Delegate Warren said...

Warren has attended:
Excel Intermediate course

Data Comparing

How do you compare data from two different worksheets to see if it appears on both of them?

Thu 25 Sep 2008, 10:51 Trainer Greg said...

RE: Data Comparing

Hello Warren,

My name is Greg Eze and I am one of the trainers at BEST.

One of the ways which you can compare data is by:

a - firstly creating a third worksheet in the same workbook,
b - using an IF statement e.g. =IF(Sheet1!A1=Sheet2!a1,"Same data","Not the same data") - this is just an example.

Is it possible for you to give me an example of the type of data you wish to compare.

Thank you

Greg

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips