Need help finding duplicates based on multiple criteria

[Zaragoza]

I have a spreadsheet with a fixed number of columns and a variable number of rows. Data is contiguous in Column B and is sorted by Serial Number.

[TABLE="width: 760"]
<colgroup><col span="2"><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD]Renewal Type[/TD]
[TD] [/TD]
[TD]Serial Number[/TD]
[TD] [/TD]
[TD]Row Type[/TD]
[TD] [/TD]
[TD]Controller Service End Date[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000000[/TD]
[TD] [/TD]
[TD]SYSTEM[/TD]
[TD] [/TD]
[TD="align: right"]10/31/2014[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000000[/TD]
[TD] [/TD]
[TD]SOFTWARE[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Software Only[/TD]
[TD] [/TD]
[TD="align: right"]70000000000[/TD]
[TD] [/TD]
[TD]STORAGE[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Shelf Only[/TD]
[TD] [/TD]
[TD="align: right"]70000000001[/TD]
[TD] [/TD]
[TD]SYSTEM[/TD]
[TD] [/TD]
[TD="align: right"]10/31/2014[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000001[/TD]
[TD] [/TD]
[TD]SOFTWARE[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000001[/TD]
[TD] [/TD]
[TD]STORAGE[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Software Only[/TD]
[TD] [/TD]
[TD="align: right"]70000000001[/TD]
[TD] [/TD]
[TD]SYSTEM[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000002[/TD]
[TD] [/TD]
[TD]SYSTEM[/TD]
[TD] [/TD]
[TD="align: right"]10/31/2014[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000002[/TD]
[TD] [/TD]
[TD]SOFTWARE[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000002[/TD]
[TD] [/TD]
[TD]STORAGE[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]70000000002[/TD]
[TD] [/TD]
[TD]SYSTEM[/TD]
[TD] [/TD]
[TD="align: right"]10/31/2017[/TD]
[/TR]
</tbody>[/TABLE]

I need to mark and then remove duplicates and it has to be done in VBA because the scrubbed data needs to be uploaded to a web application that makes it easier for a user to write to the original data set.

The challenge is that duplicates should only be identified when the values on all 4 rows are duplicated. (For instance serial 700000000001 can have multiple STORAGE lines with different end dates...or Serial 70000000001 can have more than one entry for the same system and the only difference is the Renewal Type) So to simplify. I need to mark each row that is duplicated across all 4 columns.

I'd appreciate any help at all...even if its just a nudge in the right direction. Thanks.

 

[Comfy]

Are your entries grouped at all, see example.

Which of the following two examples would be the result you wanted?

Excel 2010
	A	B	C	D	E
1	Renewal Type	Serial Number	Row Type	Controller Service End Date
2	Shelf Only	70000000001	SYSTEM	10/31/2014
3		70000000001	SOFTWARE
4		70000000001	STORAGE
5	Shelf Only	70000000001	SYSTEM	10/31/2014	Delete
6		70000000001	SOFTWARE		Delete
7		70000000001	STORAGE		Delete
8
9	Renewal Type	Serial Number	Row Type	Controller Service End Date
10	Shelf Only	70000000001	SYSTEM	10/31/2014
11		70000000001	SOFTWARE
12		70000000001	STORAGE
13	Shelf Only	70000000001	SYSTEM	10/31/2014	Delete
14		70000000001	SOFTWARE
15		70000000001	STORAGE
Sheet2

 

[Zaragoza]

Based on the data in your table the second option is what i'm looking for and No the data is not grouped. Its a long list in which only the serial number column is contiguous.