Finding Duplicates Rows of Data on a daily spreadsheet

**MattyG1406** · 07-04-2012, 06:41 AM

Hi,

I hope someone can help. I am trying to extract rows of data that have the same entries in 2 of the 5 columns of data.

I have managed to write some code that highlights them in red background, but I would like to copy the duplicates over to another sheet within the same workbook.

I've attached an example data file together with the code that I have written.

Thanks in advance,
Matt

**arlu1201** · 07-04-2012, 07:02 AM

Which are the 2 fields that should be checked for duplicates?

Should the duplicates be removed from the original set after copying to the new sheet?

**Marcol** · 07-04-2012, 07:51 AM

Try this formula approach to your problem, no need for VBa

1/. Use a helper Column in Sheet "Data", say Column G
In G2

Please Login or Register  to view this content.

Drag/Fill Down as required

2/. With Sheet "Duplicates"
In A2

Please Login or Register  to view this content.

Drag Across to Column E, then down until blank rows are returned.

3/. The best result will be if Sheet "Data" is sorted as follows ...
Sort by PurchaseCode then by GRNCode then by Date