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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!