Delete Row if same info is the same.

[TABLE="width: 1082"]

[tr]

[td]

Date

[/td]

[td]

Time

[/td]

[td]

Millitm

[/td]

[td]

Marker

[/td]

[td]

0

[/td]

[td]

Sts_00

[/td]

[td]

1

[/td]

[td]

Sts_01

[/td]

[td]

2

[/td]

[td]

Sts_02

[/td]

[td]

3

[/td]

[td]

Sts_03

[/td]

[td]

4

[/td]

[td]

Sts_04

[/td]

[td]

5

[/td]

[td]

Sts_05

[/td]

[td]

6

[/td]

[td]

Sts_06

[/td]

[td]

7

[/td]

[td]

Sts_07

[/td]

[td]

8

[/td]

[td]

Sts_08

[/td]

[td]

9

[/td]

[TD="colspan: 2"]Sts_09[/TD]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]9/1/2014[/TD]

[td]

00:00:27

[/td]

[TD="align: right"]510[/TD]

[td]

B

[/td]

[TD="align: right"]696.00[/TD]

[td][/td]

[TD="align: right"]70.00[/TD]

[td][/td]

[TD="align: right"]1.30[/TD]

[td][/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]1.50[/TD]

[td][/td]

[TD="align: right"]15.00[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]9.00[/TD]

[td][/td]

[TD="align: right"]40.00[/TD]

[td][/td]

[TD="align: right"]41.30[/TD]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]9/7/2014[/TD]

[td]

23:24:43

[/td]

[TD="align: right"]44[/TD]

[td]

S

[/td]

[TD="align: right"]1.00[/TD]

[td][/td]

[TD="align: right"]60.00[/TD]

[td][/td]

[TD="align: right"]1.50[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]1.00[/TD]

[td][/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]9.00[/TD]

[td][/td]

[TD="align: right"]40.00[/TD]

[td][/td]

[TD="align: right"]42.89[/TD]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]9/7/2014[/TD]

[td]

23:25:37

[/td]

[TD="align: right"]169[/TD]

[td]

S

[/td]

[TD="align: right"]2.00[/TD]

[td][/td]

[TD="align: right"]60.00[/TD]

[td][/td]

[TD="align: right"]1.50[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]1.00[/TD]

[td][/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]9.00[/TD]

[td][/td]

[TD="align: right"]40.00[/TD]

[td][/td]

[TD="align: right"]43.25[/TD]

[td][/td]

[td][/td]

[TD="colspan: 2"]

[/TD]

[/tr]

[tr]

[TD="align: right"]9/7/2014[/TD]

[td]

23:26:46

[/td]

[TD="align: right"]294[/TD]

[td]

S

[/td]

[TD="align: right"]3.00[/TD]

[td][/td]

[TD="align: right"]60.00[/TD]

[td][/td]

[TD="align: right"]1.50[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]1.00[/TD]

[td][/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]8.50[/TD]

[td][/td]

[TD="align: right"]40.00[/TD]

[td][/td]

[TD="align: right"]42.14[/TD]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]9/7/2014[/TD]

[td]

23:27:28

[/td]

[TD="align: right"]388[/TD]

[td]

S

[/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]60.00[/TD]

[td][/td]

[TD="align: right"]1.50[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]1.00[/TD]

[td][/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]8.50[/TD]

[td][/td]

[TD="align: right"]40.00[/TD]

[td][/td]

[TD="align: right"]42.33[/TD]

[td][/td]

[td][/td]

[/tr]

[tr]

[TD="align: right"]9/7/2014[/TD]

[td]

23:28:10

[/td]

[TD="align: right"]482[/TD]

[td]

S

[/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]60.00[/TD]

[td][/td]

[TD="align: right"]1.50[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]1.00[/TD]

[td][/td]

[TD="align: right"]4.00[/TD]

[td][/td]

[TD="align: right"]5.00[/TD]

[td][/td]

[TD="align: right"]8.50[/TD]

[td][/td]

[TD="align: right"]40.00[/TD]

[td][/td]

[TD="align: right"]42.29[/TD]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[/tr]

[/TABLE]

I am new to this but if column 9 is the same on the next row, how would I delete this info. I have like 9k lines of info that i need to look at but I only want to see when it changes. i do not care if it is sent to the next worksheet but I am totally lost.