compare and extract missing data from 2 sheets

**BIGIFA** · 09-09-2008, 07:34 PM

Hi ppl I have 2 spreadsheets that are very similar the thing I am trying to do is compare the A column in sheet 1 and 2 and if there is a value missing in sheet 2 that is present in sheet 1 I want to copy the whole row from sheet one to sheet 2 or even sheet 3 (a new sheet)

The info in column A is date and time (2006-08-01 11:40:00)

There are 7791 rows of data in sheet 1 and only 7036 so you can see i have missed a lot of data lol

if anyone can help it would be gratefully appreciated

**sglife** · 09-09-2008, 08:45 PM

After you copy the missing rows to sheet2, there will be 7791 rows, so the 2 worksheet are same, correct?
So why not just copy the worksheet1 to sheet2?

**BIGIFA** · 09-11-2008, 04:08 PM

Originally Posted by sglife

After you copy the missing rows to sheet2, there will be 7791 rows, so the 2 worksheet are same, correct?
So why not just copy the worksheet1 to sheet2?

i have added an extra colomm of data in the other sheet and added a blank colom in the same position in the other sheet. now i just need to find and add the missing rows so the blank cels in the added colom can be manual filld at a later date.

**sglife** · 09-11-2008, 11:41 PM

You need a helper column to do this
add a column beside columnA, fill up with formula


=MATCH(A1,sheet2!A:A,0)

Then select all the data you need to copy to sheet2, sort by the helper column
Then you can copy all the rows with a "#N/A" in the helper column

**farmerbb** · 08-29-2011, 11:40 AM

I have two data set files, which I can import into Excel if they are not already there. One file contains only two columns, and the first column (partnumbers) is similar to the only column in the second file. I want to find and extract any rows from the two-column file, where the first column value is not found in the second file. Another way to explain this is to have any rows where the value in column1, sheet1 that matches column 1 sheet2, should be deleted. The remaining rows in sheet1 will by definition be those whose col1 value was not found in sheet 2. I tried the ExcelIsFun but the formulas are very complex, and not explained well enough for a newby like me to understand. Actually, I think doing all this in Excell is a bit of overkill. I suspect there may well be small freeware packages out there that will do this for me.